ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I count multiple parameters? (https://www.excelbanter.com/excel-programming/310007-re-can-i-count-multiple-parameters.html)

Tom Ogilvy

Can I count multiple parameters?
 
=Sum(countif(A:A,{"11A","9A"}))

--
Regards,
Tom Ogilvy

"Jerry" wrote in message
...
I am trying to get Excel to count 2 similiar parameters within a given

range.

I need to countif for both the terms (11A and 9A). I am currently doing 2
seperate cells for this operation.

Thanks for any assistance.

Jerry





All times are GMT +1. The time now is 05:15 PM.

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