SUMIF formula for Criteria that is a range

[jlyn123]

Is there a good sumif formula or a different formula that would be good to use for a range of criteria and the criteria is all different but specific to what totals I what pulled out of a larger listing?

Thanks!

 

[solidENM]

Are you wanting to sum different categories, all at once? if so, you can use a helper column to determine which category each one falls in, tally them up, then show the sums of each category.

 

[Scott Huish]

You mean like this?

Excel 2010
	A	B	C	D	E	F	G
1	A	9			27		A
2	B	1					B
3	C	7
4	D	1
5	E	11
6	F	6
7	A	12
8	B	5
Sheet1

Cell Formulas
Range	Formula
E1	{=SUM(SUMIF(A1:B8,G1:G2,B1:B8))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[solidENM]

looks like you got it. I use a similar code in vba to tally all like items, then remove all duplicates. the result is a total of each unique item. One advantage of doing this through vba is you can use an obscure column to get the info, then delete the column afterwards. I use mine to update all A's with 21, and all B's with 6, then i remove all duplicate A's and B's = tally of each item. I can lookup the code tomorrow if you like.