Hi everyone, I am trying to do a function that will return the number of items in the worksheet with two criterias. I have tried this =countif('Aug 17-23'!C4:C38,"S3"),Countif('Aug 17-23'!D4:D38,"San") it doesn't work please any suggestions.

Try...

=SUMPRODUCT(--('Aug 17-23'!C4:C38="S3"),--('Aug 17-23'!D4:D38="San"))

Hope this helps!

In article ,
canman wrote:

Hi everyone, I am trying to do a function that will return the number of
items in the worksheet with two criterias. I have tried this
=countif('Aug 17-23'!C4:C38,"S3"),Countif('Aug 17-23'!D4:D38,"San") it
doesn't work please any suggestions.

or try
=sum(countif('Aug 17-23'!C4:C38,"S3"),Countif('Aug 17-23'!D4:D38,"San"))

"canman" wrote:


Hi everyone, I am trying to do a function that will return the number of
items in the worksheet with two criterias. I have tried this
=countif('Aug 17-23'!C4:C38,"S3"),Countif('Aug 17-23'!D4:D38,"San") it
doesn't work please any suggestions.


--
canman