ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Countif (https://www.excelbanter.com/excel-worksheet-functions/42742-countif.html)

MBL

Countif
 
what formula can I use to do a count with more than one criteria?

Peo Sjoblom

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards,

Peo Sjoblom

(No private emails please)


"MBL" wrote in message
...
what formula can I use to do a count with more than one criteria?



BenjieLop


MBL Wrote:
what formula can I use to do a count with more than one criteria?



Check out SUMPRODUCT and see if this is what you need.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=399922


Keffer

Countif
 
How to effectively use SUMPRODUCT has been a mystery to me but the
explanation you provided in this link is fantastic. Thank you so much for
taking the time to explain it and give examples.

"Peo Sjoblom" wrote:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards,

Peo Sjoblom

(No private emails please)


"MBL" wrote in message
...
what formula can I use to do a count with more than one criteria?





All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com