in cell B4:
=SUMPRODUCT((B1=$A$9:$A$56)*(B2=$B$9:$B$56)*(B3=$C$9:$C$56)*($D$9:$D$56))
but I like JohnT's better. I haven't used SUMIFS before.
in cell B4:
=SUMPRODUCT((B1=$A$9:$A$56)*(B2=$B$9:$B$56)*(B3=$C$9:$C$56)*($D$9:$D$56))
but I like JohnT's better. I haven't used SUMIFS before.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks