countifs/or

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

I have the following formula in a spreadsheet:
=COUNTIFS(A:A,"<>",C:C,"",D:D,"Received")
I now want to also count rows in column D that have "n/a" (I want to count
both "n/a" and "received".
How do I modify the function to include those?
Thank you,
Caroline
 
you should be able to stack them try:
=COUNTIFS(A:A,"<>",C:C,"",D:D,"Received")+COUNTIFS(A:A,"<>",C:C,"",D:D,"n/a")
 
Back
Top