need help with doing sums

[J4L]

Hi All,

I hope someone will be able to assist me in the below example sheet:

Excel 2007

	A	B	C	D	E	F	G	H	I	J
1	Month	Name	Type	Total					Daycase	Ordinary
2	Jan-12	name1	daycase	11				Name1	11	11
3	Feb-12	name1	ordinary	4				Name2
4	Mar-12	name3	daycase	6				Name3
5	Feb-12	name4	daycase	9				Name4
6	Feb-12	name2	ordinary	13
7	Jan-12	name2	ordinary	2
8	Jan-12	name3	ordinary	4
9	Jan-12	name4	daycase	6
10	Mar-12	name4	daycase	5
11	Mar-12	name1	ordinary	7
12

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

DATA​

From Column A11:D11 is my data - a little further on the right will be a summary of the data. What i want is a formula in I2 & J2 that will sum up Name1 with the total of daycase and ordinary, e.g. we have three names of name1, of which one has a daycase of 11 and the other two are ordinary of the totals 7 & 4... so in J2 the formula will return 11....

Perhaps a sumif statement? Any suggestions?

Thanks

 

[rallcorn]

I2 formula (Note the placement of the $ signs!)
=SUMIFS($D:$D,$B:$B,$H2,$C:$C,I$1)
Copy formula to J2 and copy both I2 & J2 down to other rows in those columns

 

[par60056]

This looks like a simple pivot table. Name in the rows and type in the columns and total in the value.

 

[West Man]

In I2 and copied down try: =SUMPRODUCT(--($B$2:$B$11=H2),--($C$2:$C$11="daycase"),($D$2:$D$11))

For J2 just change the literal daycase to ordinary

 

[par60056]

In I2 and copied down try: =SUMPRODUCT(--($B$2:$B$11=H2),--($C$2:$C$11="daycase"),($D$2:$D$11))

For J2 just change the literal daycase to ordinary

West,
why type in the literals? Why not use ($C$2:$C$11=I$1) Also, don't you need a $ on H2 so it is $H2?

 

[J4L]

West,
why type in the literals? Why not use ($C$2:$C$11=I$1) Also, don't you need a $ on H2 so it is $H2?

Thanks to everyone, all the examples given worked by a little tweaking around