countif
I want to count the occurrences of multiple character strings eg. "AB" "XD"
and "CD". Is there an easier way than = (countif(1:100), "AB") + (countif(1:100), "XD") etc. |
countif
=SUM(COUNTIF(A1:a100,{"AB","xd","cd"}))
AJ wrote: I want to count the occurrences of multiple character strings eg. "AB" "XD" and "CD". Is there an easier way than = (countif(1:100), "AB") + (countif(1:100), "XD") etc. -- Dave Peterson |
countif
Thank you! Exactly what I am looking for. I tried to put something like
this together but didn't realize that I would have to use "SUM" and I admit that I don't know when to use the characters "{" and "}" in a formula. "Dave Peterson" wrote: =SUM(COUNTIF(A1:a100,{"AB","xd","cd"})) AJ wrote: I want to count the occurrences of multiple character strings eg. "AB" "XD" and "CD". Is there an easier way than = (countif(1:100), "AB") + (countif(1:100), "XD") etc. -- Dave Peterson |
All times are GMT +1. The time now is 06:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com