Without googling it...
Jul. 14th, 2005 12:38 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
lovingbothIn Excel, how do you count the number of times a particular string appears in a range of cells?
You're allowed, nay encouraged, to use the "help" facility, including the ever helpful paperclip.
(Oh, using your finger and going 'one, two, three..' doesn't count! :) I'm looking for a formula.)
It must be a fairly frequent need and I'm curious as to how many people know or can use the "help" to find out. When I get home, I'll see if the lovely OpenOffice is any better.
You're allowed, nay encouraged, to use the "help" facility, including the ever helpful paperclip.
(Oh, using your finger and going 'one, two, three..' doesn't count! :) I'm looking for a formula.)
It must be a fairly frequent need and I'm curious as to how many people know or can use the "help" to find out. When I get home, I'll see if the lovely OpenOffice is any better.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
(no subject)
Date: 2005-07-14 11:53 am (UTC)=COUNTIF(cell-range, "string-to-match")
Or have I missed something?
(no subject)
Date: 2005-07-14 12:00 pm (UTC)(no subject)
Date: 2005-07-14 12:02 pm (UTC)About two minutes with the paperclip in Excel led me to the COUNTIF function, but it sadly doesn't seem to do substring searches, and I can't work out how I'd make it do that. Certainly no obvious command, I guess you'd use an IF as the criteria to the COUNTIF, with a text search for your search string as the inner conditional.
Openoffice also has a COUNTIF, but it supports regular expressions. However, the help was no good at telling me the basic syntax to enter formula, so I gave up after about five minutes.