Hi guys,
getting a #value error when doing countifs on spreadhseet attached.
I am trying to do:
=COUNTIFS B2:B16 AND H2:H16 "yes"
can anyone tell me where I am going wrong please?
Hi guys,
getting a #value error when doing countifs on spreadhseet attached.
I am trying to do:
=COUNTIFS B2:B16 AND H2:H16 "yes"
can anyone tell me where I am going wrong please?
Thanks,
R.
Try countif+countif, or =SUMPRODUCT((B2:B16="YES")*(H2:H16="YES"))
Click the * to say thanks.
countif + countif works... thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks