SUMIF function

[no speed limit]

hi,

I wonder if the SUMIF function can handle more than one criteria, seperated in two colums?

[IcyBricks]

Use =SUMIFS().

http://office.microsoft.com/en-us/ex...010342933.aspx

[no speed limit]

thanks! this works just as i wanted!

[Tony Valko]

Is something like this what you had in mind?

Data Range

	A	B	C	D	E	F	G
1	Name	Region	Sales	------	Name	Region	Sales
2	Sam	North	120		Sam	North	420
3	Tammy	West	255
4	Sam	North	300
5	Bill	West	127
6	Lisa	South	455
7	Lisa	South	600
8	Sam	West	210
9	Bill	South	333
10	Tammy	East	125

This formula entered in G2:

=SUMIFS(C2:C10,A2:A10,E2,B2:B10,F2)