SUMPRODUCT - DIFFERENT DATES

[Danny]

Hi,

Please edit my formula below so I can add entries dated 3/30/2007, 4/16/2007
and 5/15/2007

=SUMPRODUCT(--($I$2:$I1116=DATE(2007,3,30)),-($J$2:$J1116=""),$G$2:$G1116)

Thank you.

 

[T. Valko]

Use cells to hold your date criteria:

M2 = 3/30/2007
M3 = 4/16/2007
M4 = 5/15/2007

=SUMPRODUCT($G$2:$G1116,--(ISNUMBER(MATCH($I$2:$I1116,$M$2:$M$4,0))),--($J$2:$J1116=""))