Text Counts

[Cirrusxxx]

I have a column named "Selection", in which it is pertaining to an upcoming event in which the participants can select either a "Beef", "Chicken", or "Vegetarian" entree. And for the people not attending it's simply marked "N/A". I'm trying to get a count of each using a formula, but can't seem to get any one right. I want:

Beef: Count of how many "Beef"
Chicken: Count of how many "Chicken"
Veg: Count of how many "Vegetarian"

Any guidance would be greatly appreciated. Thanks.

[BigBas]

If your selections are in Column B, cells B2:B100, use these formulas


=COUNTIF(B2:B100,"BEEF")
=COUNTIF(B2:B100,"CHICKEN")
=COUNTIF(B2:B100,"VEGETARIAN")

Hope this helps.

EDIT TO ADD: You should consider setting up a data validation on that column, because these formulas will only count information if it is entered exactly. So, if you misspell chicken, for example, in one cell, it will not count it.

[VBA Noob]

Try

=COUNTIF(A:A,"beef")

VBA Noob

[Cirrusxxx]

First one worked. Tried it before but was putting a space after the comma. Thanks

[BigBas]

Glad it worked for you

[endortrails]

Hi

Along the same line......

Column D contains expense totals in dollars. Column E contains the category of the expense (example: food, auto, entertainment,etc.).

What formula would total all items in Column D categorized as "food" in Column E?

Thanks in advance!

[BigBas]

=SUMIF(D1:D100,"food",E1:E100)

Assuming you have populated rows 1-100.