Sum IF

[BIGGAZ]

Hi, I would like to sum data in a column based on the results of 2 other columns.

Machine 1	Monday	3
Machine 3	Wednesday	2
Machine 2	Monday	5
Machine 1	Thursday	7
Machine 1	Monday	6

So i need to sum column C in a table

Machine 1	Count	Machine 2	Count
Monday		Monday
Tuesday		Tuesday
Wednesday		Wednesday

In B2 it needs to check for Machine 1 and Monday then add every occurence etc.

Thank You
Gary

 

[awoohaw]

How is this:

Book1
	A	B	C	D
3	Machine 1	Monday	3
4	Machine 3	Wednesday	2
5	Machine 2	Monday	5
6	Machine 1	Thursday	7
7	Machine 1	Monday	6
8
9	So i need to sum column C in a table
10
11	Machine 1	Count	Machine 2	Count
12	Monday	9	Monday	5
13	Tuesday	0	Tuesday	0
14	Wednesday	0	Wednesday	0
Sheet7

Cell Formulas
Range	Formula
B12:B14	B12	=SUMIFS($C$3:$C$7,$A$3:$A$7,$A$11,$B$3:$B$7,$A12)
D12:D14	D12	=SUMIFS($C$3:$C$7,$A$3:$A$7,$C$11,$B$3:$B$7,$C12)

 

[BIGGAZ]

How is this:

Book1
	A	B	C	D
3	Machine 1	Monday	3
4	Machine 3	Wednesday	2
5	Machine 2	Monday	5
6	Machine 1	Thursday	7
7	Machine 1	Monday	6
8
9	So i need to sum column C in a table
10
11	Machine 1	Count	Machine 2	Count
12	Monday	9	Monday	5
13	Tuesday	0	Tuesday	0
14	Wednesday	0	Wednesday	0
Sheet7

Cell Formulas
Range	Formula
B12:B14	B12	=SUMIFS($C$3:$C$7,$A$3:$A$7,$A$11,$B$3:$B$7,$A12)
D12:D14	D12	=SUMIFS($C$3:$C$7,$A$3:$A$7,$C$11,$B$3:$B$7,$C12)

Hi,

That seems to of worked. What is the first part used for? Range B12:B14 its not in the formula.

 

[awoohaw]

do you mean the first column in the formula grid under the mini workbook? The first column is the range where there formula in the 2nd column is located. There are formulas in cells B12, B13, B14, and D12, D13, D14. I just did the formulas in the empty cells under the word COUNT from your initial mini workbook post.

I'm happy you have a solution! Best wishes.