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.