how to use multiple criteria with countif function in excel
 

Please, give the solution within 10 min, if possible

how to use multiple criteria with countif function in excel
 

Use a Helper column to combine the criteria into a single cell.
--
Gary''s Student - gsnu200724

how to use multiple criteria with countif function in excel
 

SUMPRODUCT

--
Don Guillett
SalesAid Software

"Debu" wrote in message
...
Please, give the solution within 10 min, if possible

how to use multiple criteria with countif function in excel
 

Good addition.

Also the difference in two COUNTIF functions to test greater than one
criteria and less than the other.
--
Gary''s Student - gsnu200724


"Don Guillett" wrote:

SUMPRODUCT

--
Don Guillett
SalesAid Software

"Debu" wrote in message
...
Please, give the solution within 10 min, if possible

how to use multiple criteria with countif function in excel
 

I was going to say "Use DCOUNT", but I'm obviously too late.

NickHK

"Debu" wrote in message
...
Please, give the solution within 10 min, if possible