I need some help.
I am using
=SUMPRODUCT(($C$8:$C$4372="INCOMPLETE")*($D$8:$D$4372="VEDI ANDERSON")) and it is working fine.
However I want to adjust it to ALSO count number of dates in the first column so I tried (UNSUCCESSFULLY)
=SUMPRODUCT(($C$8:$C$4372,">="&today())*($D$8:$D$4372="VEDI ANDERSON"))
Please help me...just a novice.
Bookmarks