Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct with And? | Excel Discussion (Misc queries) | |||
Help with SUMPRODUCT | Excel Discussion (Misc queries) |