=SUMIF($D$7:$D$98,"*BD",$O$7:$O$98)
This formula should sum anything in the Gift Card column (O) that has "BD" in the Pay Type column (D). For some reason it does not include "SALARY - BD-VP". The same thing happens when I use the SUMIFS formula.
The sum total should appear in L198 for Incentives Tax - BD (gift cards) on the attached spreadsheet. If the formula was working, the total amount in L198 would be $200 not $150.
I'm using Office 2016 Excel 2016. What am I doing wrong?