Here, try this:
=SUMPRODUCT(--($D$3:$D$11="P"), --($C$3:$C$11=A19), $B$3:$B$11)
Here, try this:
=SUMPRODUCT(--($D$3:$D$11="P"), --($C$3:$C$11=A19), $B$3:$B$11)
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks