countif

MelissaG.

how do I do a total count of PPAP rejected and PPAP approved along with adding blank cells together if the FAI Report or PPAP column says PPAP?

Brian_Richardson

You may want to use a Summary Field for this, or of course you can put this in a cell somewhere:

PPAP Rejected only: =COUNTIF(Status:Status,"PPAP Rejected")

PPAP Rejected + blank cells if FAI Report or PPAP says "PPAP":

=COUNTIF(Status:Status,"PPAP Rejected")+COUNTIFS(Status:Status,"",[FAI Report or PPAP]:[FAI Report or PPAP],"PPAP")

MelissaG.

Brian , Thank you for this. It was helpful. However it is counting more than what I have by 6 rows and I don't have any blank rows. What would cause that?

Brian_Richardson

Break up the formula and see which one of the Countifs are giving you extras. You might have some “surprise” rows a page down or that have been filtered from view without realizing it.

MelissaG.

Thanks Brian I did figure it out :)