Howdy,
on sheet with multiple tabs (one for each day) I have names in ColA and values in ColB
each name could be on different rows and the value on the same row as the name..
some days might have the name missing.
I want to get a Week totals so I am using SUM(IFERROR(lookup("bob",'1st'!,$A$3:$A$35,'1st'!,$B$3:$B$35),0) and so on for every day (tab: 2nd, 3rd..)
so if bob is not on day 4th it will just by pass it... \
I do get a result, but when I sum them manually I get a different one..
what am I doing wrong?
on sheet with multiple tabs (one for each day) I have names in ColA and values in ColB
each name could be on different rows and the value on the same row as the name..
some days might have the name missing.
I want to get a Week totals so I am using SUM(IFERROR(lookup("bob",'1st'!,$A$3:$A$35,'1st'!,$B$3:$B$35),0) and so on for every day (tab: 2nd, 3rd..)
so if bob is not on day 4th it will just by pass it... \
I do get a result, but when I sum them manually I get a different one..
what am I doing wrong?