=SUMPRODUCT
 

I have the below spreadsheet. In a separate spreadsheet, I need a
formula to calcuate the cost (column C) of labor (Column A) under
346620.01.03.01 (Column B). I've tried the below formula, but it's not
working. Any suggestions?

=SUMPRODUCT(--('[Costs.xls]08 Oct'!$A:$A="ALLOTHER")*--('[Costs.xls]08
Oct'!$B:$B="346620.01.03.01")*--('[Costs.xls]08 Oct'!$E:$E))

Any suggestions?

Column A Column B Column C
ALLOTHER 346620.01.01.01 $51.05
LABOR 346620.01.03.01 $306,057.63
LABOR 346620.01.05 $684,537.00
TRAVEL 346620.01.07 $1,905.75

I've tried the below formula, but it's not working. Any suggestions?

=SUMPRODUCT(--('[Costs.xls]08 Oct'!$A:$A="ALLOTHER")*--('[Costs.xls]08
Oct'!$B:$B="346620.01.03.01")*--('[Costs.xls]08 Oct'!$E:$E))

=SUMPRODUCT
 

Hi

You say your labour costs are in column C, but your formula is taking values
from column I
In the data shown, there is no value for AllOther that has a value in column
of 346620.01.03.01

Just as an aside, it doesn't affect the working of your formula, you should
normally use ,-- not *--
With * you don't need the double unary minus as well.
--
Regards
Roger Govier

"LHerring" wrote in message
...
I have the below spreadsheet. In a separate spreadsheet, I need a
formula to calcuate the cost (column C) of labor (Column A) under
346620.01.03.01 (Column B). I've tried the below formula, but it's not
working. Any suggestions?

=SUMPRODUCT(--('[Costs.xls]08 Oct'!$A:$A="ALLOTHER")*--('[Costs.xls]08
Oct'!$B:$B="346620.01.03.01")*--('[Costs.xls]08 Oct'!$E:$E))

Any suggestions?

Column A Column B Column C
ALLOTHER 346620.01.01.01 $51.05
LABOR 346620.01.03.01 $306,057.63
LABOR 346620.01.05 $684,537.00
TRAVEL 346620.01.07 $1,905.75

I've tried the below formula, but it's not working. Any suggestions?

=SUMPRODUCT(--('[Costs.xls]08 Oct'!$A:$A="ALLOTHER")*--('[Costs.xls]08
Oct'!$B:$B="346620.01.03.01")*--('[Costs.xls]08 Oct'!$E:$E))

=SUMPRODUCT
 

You can not use whole column prior to XL-2007


"LHerring" wrote:

I have the below spreadsheet. In a separate spreadsheet, I need a
formula to calcuate the cost (column C) of labor (Column A) under
346620.01.03.01 (Column B). I've tried the below formula, but it's not
working. Any suggestions?

=SUMPRODUCT(--('[Costs.xls]08 Oct'!$A:$A="ALLOTHER")*--('[Costs.xls]08
Oct'!$B:$B="346620.01.03.01")*--('[Costs.xls]08 Oct'!$E:$E))

Any suggestions?

Column A Column B Column C
ALLOTHER 346620.01.01.01 $51.05
LABOR 346620.01.03.01 $306,057.63
LABOR 346620.01.05 $684,537.00
TRAVEL 346620.01.07 $1,905.75

I've tried the below formula, but it's not working. Any suggestions?

=SUMPRODUCT(--('[Costs.xls]08 Oct'!$A:$A="ALLOTHER")*--('[Costs.xls]08
Oct'!$B:$B="346620.01.03.01")*--('[Costs.xls]08 Oct'!$E:$E))