Another one.....
In F3
and then drag across and down.![]()
=SUMPRODUCT(--($A$2:$A$17=$E3),--($B$2:$B$17=F$2),$C$2:$C$17)
Another one.....
In F3
and then drag across and down.![]()
=SUMPRODUCT(--($A$2:$A$17=$E3),--($B$2:$B$17=F$2),$C$2:$C$17)
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks