thanx a lot ...it working.. ---------- Post added at 11:39 PM ---------- Previous post was at 11:37 PM ---------- Originally Posted by CheshireCat Try this: =SUMPRODUCT(--($A$2:$A$14=$G2),--($C$2:$C$14=H$1),$B$2:$B$14) Thanx a lot ..it's working..
=SUMPRODUCT(--($A$2:$A$14=$G2),--($C$2:$C$14=H$1),$B$2:$B$14)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks