Try this in C18:
=SUMPRODUCT(($A$2:$A$12=A18)*($B$2:$B$12=B18),$C$2:$C$12) and copy down.
Try this in C18:
=SUMPRODUCT(($A$2:$A$12=A18)*($B$2:$B$12=B18),$C$2:$C$12) and copy down.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks