Tech Support Guy banner

Lookup Sum of Table by Week

587 Views 3 Replies 2 Participants Last post by  estyMonsty
Hi All,

I'm trying to look up / match the weekly sum without putting in a summary column per week.
e.g. return the sum of ('John'!)B5:H5 into cell ('Weekly Summary'!)B4. Look up value column A.

I've attached an example of what I'm trying to do.


Not open for further replies.
1 - 4 of 4 Posts
Hello Monsty,

I am assuming that you are using MS Excel. You just need to tweak it a little and put the linked cells within the parenthesis. ;)


I hope this helps,
I have thousands of entries and require to match the item with the person and week producing the sum as the result.

Currently the formula I am using (but this is because I have a column with the total monthly sum in it e.g. creating a new column in R):
=IFNA(INDIRECT("'"&{cell referenced with name e.g.B$3}&"'!{column referenced of total monthly hours e.g.R}"&MATCH({cell referenced to match item e.g. $A4},INDIRECT("'"&{cell referenced with name e.g.B$3}&"'!{column:column item referenced e.g.$A:$A }"),0)),0)

I don't want to have to create new columns and was wondering if it was possible to incorporate the sum formula into an indirect match formula or if there was an easier / less manual way.
Figured it out. There may be an easier way but:


Phew! Thanks for the direction.
1 - 4 of 4 Posts
Not open for further replies.