Excel 2007 Nested Sumif's

T

TKS_Mark

I want to sum columns of data only if two neighboring columns match two
separate criteria. For instance, I'm in worksheet, "wksht1" at column C. I
named column A "ActCdeSum". In another worksheet, I have three named
columns, "Area10", "ActCdeG10", and "_CstG10".

I want to sum the contents of "_CstG10" only if x "ActCdeG10" matches
"ActCdeSum" and "Area10" is has the text GB.

wksht1 columns:
ActCdeSum, The Current Cell containing the formula

the other worksheet's columns:
"Area10", "ActCdeG10", and "_CstG10"

Please help.

Thanks!
 
H

Harlan Grove

TKS_Mark said:
I want to sum columns of data only if two neighboring columns match two
separate criteria. For instance, I'm in worksheet, "wksht1" at column C.
I named column A "ActCdeSum". In another worksheet, I have three named
columns, "Area10", "ActCdeG10", and "_CstG10".

I want to sum the contents of "_CstG10" only if x "ActCdeG10" matches
"ActCdeSum" and "Area10" is has the text GB.
Click to expand...
....

So you want multiple cell ActCdeG10 to match item-by-item against multiple
cell ActCdeSum? If so, you can't use SUMIFS. You'd need to use SUMPRODUCT.

=SUMPRODUCT((ActCdeG10=ActCdeSum)*(Area10="GB"),_CstG10)

Again, you'd be better off asking these kinds of application-specific
questions in application-specific newsgroups.
 
Top