Count if matches criteria?

Rainweaver

New Member
Joined
Feb 16, 2017
Messages
5
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.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Rainweaver

New Member
Joined
Feb 16, 2017
Messages
5
OOF forum formatting, why must you eat my spaces!?!

Lemme try that again since I can't edit :confused:

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

New Member
Joined
Feb 16, 2017
Messages
5
HA! I figured it out, the bugger. Multi-criteria =countifs
You can ignore me now, hehe :rolleyes:
 

Forum statistics

Threads
1,136,322
Messages
5,675,085
Members
419,549
Latest member
EliteBeat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top