So I made a compound SUMIF statement, as follows:
=SUM(SUMIF($K1,"VI",$G1),SUMIF($F1,"P",$G1))
(If the characters "VI" are in column K, it will add column G.
& If the character "P" is in column F, it will add column G.
The cell with the formula will add column G IF it has VI and P in the other columns.)
I have no idea if that makes sense. Either way, the formula seems to work but it's resulting in 0 when it should be 475. Is there a way to simplify what I have or change it so it's working correctly.
Here is a screenshot if it helps. My explination was... bad.
sumif.JPG
Bookmarks