Use of SUMIF possible?
 

Hello,
I need to create a formula that needs to sum all values based on 2 criterias.
The criteria columns are ColumnE to find value SECY AND ColumnA to find
value 211. The given sum total will come from ColumnM.

I tried using this: It didn't work.
=SUM(('[AI 50 Download 0405.xls]AI-50 0405 work
copy'!$E$6:$E$1067="SECY")*('[AI 50 Download 0405.xls]AI-50 0405 work
copy'!$A$6:$A$1067="211")*'[AI 50 Download 0405.xls]AI-50 0405 work
copy'!$M$6:$M$1067)

Any thoughts?
Thanks,
Rich

Use of SUMIF possible?
 

Sumproduct will work for you

=SUMPRODUCT(($A$1:$A$10="SECY")*($E$1:$E$10=211)*$ M$1:$M$10)

Here is a link to a web site...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Rich" wrote:

Hello,
I need to create a formula that needs to sum all values based on 2 criterias.
The criteria columns are ColumnE to find value SECY AND ColumnA to find
value 211. The given sum total will come from ColumnM.

I tried using this: It didn't work.
=SUM(('[AI 50 Download 0405.xls]AI-50 0405 work
copy'!$E$6:$E$1067="SECY")*('[AI 50 Download 0405.xls]AI-50 0405 work
copy'!$A$6:$A$1067="211")*'[AI 50 Download 0405.xls]AI-50 0405 work
copy'!$M$6:$M$1067)

Any thoughts?
Thanks,
Rich