Hi All,
I have scoured various responses and can't seem to find an answer that suit s my situation.
Basically, I would like to match 3 criteria based on a range (Note: using excel 2003)
Column A includes names, B includes Dates, C includes Yes/no
I have tried a sumproduct but does not returns 0:
=SUMPRODUCT(($A$2:$A$7=$E3)*($B$2:$B$7>="Jan-13")*($C$2:$C$7=$K$3))
Anyone know where I may have gone wrong?
Regards
Tim
Bookmarks