Help

[canman]

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'!D438,"San") it
doesn't work please any suggestions.

 

[Domenic]

Try...

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

Hope this helps!

 

[bj]

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