Count if matches criteria?

[Rainweaver]

I'm sure Excel can do this, and you folks have saved my hide in the past so here we go!

I've fussed a bit with countif and vlookup, but I have a new wrench thrown in today.

I have a worksheet and I am trying to get it to count if data is entered into one column based on if a specific text is entered into another column.

Let me see if I can draw this better than I can explain it...

Name Code Breakfast Lunch
Sue 4 x
Bobby 2 x
Mary 2 x x
Billy 1 x

Ok, so I have my four kids, and they are coded depending on what part of their meal is reimbursed by the state. I would LIKE to be able to populate a little chart at the bottom, one per each meal type, showing how many kids per code got a meal that day.

So if I had my Breakfast and Lunch charts, using this data, it would look like:

Breakfast Lunch
1 1 1
2 1 2 2
3 3
4 1 4

Is there a WAY to do that? I am trying to make this form as user-friendly and as "error-resistant" as possible by eliminating as much math as I can for my users.

 

[Rainweaver]

OOF forum formatting, why must you eat my spaces!?!

Lemme try that again since I can't edit

Name --- Code --- Breakfast --- Lunch
Sue ----- 4 ------- x
Bobby -- 2 ---------------------- x
Mary --- 2 -------- x ------------ x
Billy ---- 1 -------- x


Breakfast --- Lunch
1 --- 1 ------ 1 --- 0
2 --- 1 ------ 2 --- 2
3 --- 0 ------ 3 --- 0
4 --- 1 ------ 4 --- 0

 

[Rainweaver]

HA! I figured it out, the bugger. Multi-criteria =countifs
You can ignore me now, hehe