=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))
|