Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can lookup return cell reference istead of "text" for sumif?
I am trying to use a lookup-function to determine a different sum
range for several criteria. Like so: =Sumif($A$7:$A$1447;"<"&X3;vlookup(e3;AT3:AU11;2;f alse)-Sumif($A$7:$A $1447;"<"&y3;vlookup(e3;AT3:AU11;2;false) The problem is that the vlookup returns text and not the cell reference. Is there a way to get the answer from the lookup expressed as cell reference instead of text, since sumif can't use text, just the cell reference? I use it to calculate the number of hours the staff should be paid, so it's different from weekdays to saturdays, holidays and sundays in at3 to at11 i have the days (1 for sunday) of the week and in au3 to au11 i have the ranges for the reference table with pay per minute. 1 sheet1!$E$7:$E$1447 2 sheet1!$C$7:$C$1447 3 sheet1!$C$7:$C$1447 4 sheet1!$C$7:$C$1447 5 sheet1!$C$7:$C$1447 6 sheet1!$C$7:$C$1447 7 sheet1!$D$7:$D$1447 holliday sheet1!$F$7:$F$1447 eve sheet1!$G$7:$G$1447 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can lookup return cell reference istead of "text" for sumif?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Thread "Return" Without Leaving the Cell | Excel Discussion (Misc queries) | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
Return cell reference instead of text from within lookup() functio | Excel Worksheet Functions | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) |