Thread: Tallying types based on cell contents

Hello Excel Forum,

Pardon my ignorance regarding nomenclature.

I am looking to tally types of things based on a cell's contents (would be the number 1 or 2), not find the sum of the contents over this range of cells. Example: for a pre-planned lunch and dinner menu 5 people may choose from option 1 or option 2, for each meal. If I was to input a variety of options how can I tally how many of each option was needed for the day? Another variable that needs to be considered is whether or not the option is a small or large portion.

I have attached a sample file. I have used 5 people but the spreadsheet would actually have to account for 50+ people.

Any advice will be greatly appreciated as I can't find the help I need in the help section within Excel 2004 for Mac.

Thank you,

Liam

you can't count on cell colour. without code. you need some other way of indicating large/ small
=COUNTIF(C2:D6,2) counts 2's and
=COUNTIF(C2:D6,1) counts 1's
perhaps us 1L and 1S
then
=COUNTIF(C2:D6,"1L")
=COUNTIF(C2:D6,"1S")