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

can lookup return cell reference istead of "text" for sumif?
 

Check your other post.

wrote:

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

--

Dave Peterson