hI GUYS,

i HAVE A colmn D with cells containing P and R

How do I write a formula to say count data with P and R?

At the moment I have this:

=COUNTIFS(C:C, "NULL", D:D, "P") I want to add count R from column D too

Please help and advise.

Thank you!