Sum column based upon corresponding values

[Dan-X !]

I know this is probably simple but I can't get anything to work. I
have a formula that I took from another document to use in a new
project. The formula looks at the values of a specific range in
another workbook and then counts the values of a corresponding column.
However, I want to change this formula so that it sums the values
instead of counting.

=SUMPRODUCT((QM03_template.xls!$A$2:$A$2000={"FEMA Manual
Determination"})*(QM03_template.xls!$E$2:$E$2000<>""))

 

[Bernard Liengme]

What column to SUM, I will assume F
=SUMPRODUCT((QM03_template.xls!$A$2:$A$2000={"FEMA Manual

Determination"})*(QM03_template.xls!$E$2:$E$2000<>"")*QM03_template.xls!$F$2:$F$2000))

Why the {} in ={"FEMA Manual Determination"}

For more on SUMPRODUCT visit
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html


best wishes

 

[Earl Kiosterud]

Dan,

Your formula counts rows with "FEMA..." in column A and are nonblank in
column E. If the values to be summed are in column E, try:

=SUMPRODUCT((QM03_template.xls!$A$2:$A$2000={"FEMA Manual
Determination"})*(QM03_template.xls!$E$2:$E$2000))