Two criterias for countifs

[rayted]

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!

[Glenn Kennedy]

One way:

=SUM(COUNTIFS(C:C, "NULL", D:D, {"P","R"}))

[rayted]

thank you Glenn!

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.