Hi
=SUMPRODUCT(--(A1:A6=1),--(B1:B6="Alan"),C1:C6)
the critertia can be cell references holding the criteria values.
Richard
Hi
=SUMPRODUCT(--(A1:A6=1),--(B1:B6="Alan"),C1:C6)
the critertia can be cell references holding the criteria values.
Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks