# Count if matches criteria?

#### Rainweaver

##### New Member
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
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

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

Replies
8
Views
211
Replies
11
Views
85
Replies
3
Views
578
Replies
6
Views
121
Replies
0
Views
254

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.

### Which adblocker are you using?

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

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