Hello Folks,
I'm looking for a little help with the following formula.
=SUMPRODUCT((Data!$A$2:$A$10000>="01/01/14")*(Data!$A$2:$A$10000<="01/31/14")*(Data!$I$2:$I$10000="Bulk")*(Data!$K$2:$K$10000=$A3)*(Data!$P$2:$P$10000=$B3)*(Data!$Q$2:$Q$10000=$C3))
Do I need to add datevalue to my formula? Or format it differently?
Its just giving me a 0 result right now but it should be 7 instances.
Bookmarks