Thank you very much for these perfect solutions
I wonder why can't sumproduct used directly in VBA although it is built in worksheetfunction .. that's weird