ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help (https://www.excelbanter.com/excel-worksheet-functions/45526-help.html)

canman

Help

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.

Domenic

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

All times are GMT +1. The time now is 12:51 PM.