Help with IF statement formula in summing prior data.

**asburytl** · 09-06-2011, 02:01 PM

I'm looking for help with an if statement to sum data from multiple tabs of prior data.

In the data cell M8, what would be the most effeicent formula to pull the following information.

What I need help with:

I need cell M8 to display the total YTD value based of prior tabs.

So, for example:

If cell b2 is = to 17 then I need to display the sum of the same value from wk "Yp09-WorkCenter Summary Wk01" through "Yp09-WorkCenter Summary Wk17"

Another example:

If cell b2 is = to 16 then I need to display the sum of the same value from wk "Yp09-WorkCenter Summary Wk01" through "Yp09-WorkCenter Summary Wk16"

If anyone can provide some insight I would be very much appreciative, because I'm stuck in my own tracks on this one.

Thanks!

**NBVC** · 09-06-2011, 02:16 PM

Try:

Please Login or Register  to view this content.

copied down

**asburytl** · 09-06-2011, 03:36 PM

It seems like that will work perfectly, however, it is not pulling the correct total for some reason?

Not sure if I was confusing or not in my explaination, so, I'll throw it out there again:

If b2 says 17, it should sum 1-17
If b2 says 16, it should sum 1-16.

Thanks again for all your help, I really appreciate it....

**NBVC** · 09-06-2011, 03:42 PM

Yes, I should've checked it a bit better... doesn't look like the INDEX will work here to get the multiple sheets... so we'll need to change it to:

Please Login or Register  to view this content.

In this case instead of identifying the column to sum by number, e.g. 8, you will have to actually define the range of that 8th column, i.e. $I$2:$I$502