mcarterbrown.com - View Single Post

Kindred · 08-27-2007, 04:24 PM

Mmm....you lost me a little bit there, but it SOUNDS like the function you're looking for is "countif". See the screen shot below.

The formula is visible in the formula bar up top, in this case, =CountIF(B1:B6,"yes") will count all instancesof the word "yes".

countif.jpg

08-27-2007, 04:24 PM	#2 (permalink)
Kindred Mod & Underwear Model Join Date: Mar 2006 Location: Neshanic Station, NJ	Mmm....you lost me a little bit there, but it SOUNDS like the function you're looking for is "countif". See the screen shot below. The formula is visible in the formula bar up top, in this case, =CountIF(B1:B6,"yes") will count all instancesof the word "yes". countif.jpg __________________ Strive for that moment when you're only a slice of pizza and a hooker away from paradise.