Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text in SUMPRODUCT
Hello,
I can't figure out why the following keeps happening. I have a list of data with the date, type of machine, chargable hours, and non- chargable hours. Why is it that I can do this: =SUMPRODUCT(('2007-2008 Breakdown'!$C$2:$C $2255="Crusher")*(MONTH('2007-2008 Breakdown'!$A$2:$A $2255)=11)*('2007-2008 Breakdown'!$E$2:$E$2255)) With the word "Crusher" in this formula, it returns the right number. If I write the word "Crusher" in the cell beside this one and reference it as the cell value: =SUMPRODUCT(('2007-2008 Breakdown'!$C$2:$C $2255="A4")*(MONTH('2007-2008 Breakdown'!$A$2:$A$2255)=11)*('2007-2008 Breakdown'!$E$2:$E$2255)) It returns zero. Is there any way to use the cells instead of typing each word. Thanks in advance. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct text if | Excel Worksheet Functions | |||
maybe by sumproduct or some other way with text. | Excel Worksheet Functions | |||
SUMPRODUCT but with text containing | Excel Worksheet Functions | |||
Sumproduct Text | Excel Discussion (Misc queries) | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions |