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")

"Caroline" wrote:

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

Think you need to revert to a Sumproduct function:

=Sumproduct(--(A:A<""),--(C:C=""),((D:D="Received")+(D:D="n/a")))


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123188

=SUM(COUNTIFS(A:A,"<",C:C,"",D:D,{"Received","n/a"}))


"Caroline" wrote:

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