Calculation Problems - Redux

[Adam]

Thank you for your prompt response. Here is the formula
and how it is supposed to work.

=SUM('BDR Daily - Day 6'!
$I$160+$I$161+$I$163+$I$170+$I$171+$I$172+$I$174+$I$178+$I
$179+$I$180+$I$181+$I$188)

I have 35 days in a workbook all labled "BDR Daily - Day
1" through "BDR Daily - Day 35"

The formula doesn't work on any day I just happened to
use Page 6 as an example.

The above formula pulls into a daily sheet used for
reporting that day's activities to management.

Starting from I70 or $I$170 as it's known doesn't pull
any data from the other Excel sheets.

So, $I$170 pulls data from 6 individual sources but that
forumla works fine and the data appears in the box $I$170
pulls from but $I$170 is not passing the data to the
final report.

Sorry if this isn't clear. Please let me know if you
need any more detials or if I can explain it better?

Thanks.

 

[Frank Kabel]

Hi Adam
probably the problem is that the formula in your post just gets the
first value form Day 6. All other values are form the current sheet.
You may try the following:
=SUM('BDR Daily - Day 6'!$I$160+'BDR Daily - Day 6'!$I$161+'BDR Daily -
Day 6'!$I$163+'BDR Daily - Day 6'!$I$170+'BDR Daily - Day
6'!$I$171+'BDR Daily - Day 6'!$I$172+'BDR Daily - Day 6'!$I$174+'BDR
Daily - Day 6'!$I$178+'BDR Daily - Day 6'!$I$179+'BDR Daily - Day
6'!$I$180+'BDR Daily - Day 6'!$I$181+'BDR Daily - Day 6'!$I$188)

or somewhat shorter:
=SUM('BDR Daily - Day 6'!$I$160:$I$161+'BDR Daily - Day 6'!$I$163+'BDR
Daily - Day 6'!$I$170:$I$172+'BDR Daily - Day 6'!$I$174+'BDR Daily -
Day 6'!$I$178:$I$181+'BDR Daily - Day 6'!$I$188)

you have to use the sheet identifier for all cell references!

 

[Adam]

Just as an FYI, the forumla under $I$170 is as follows:


=SUM(I27+AI27+BI27+I75+AI75+BI75)

This is what pulls the data from the other tables ont he
page.

 

[Guest]

Frank, thank you. I was afraid that was the case... I
modified the formula and used the identifier once
thinking it would pull from all the other cells on that
sheet but that is apparently not the case.

 

[Ron Rosenfeld]

Thank you for your prompt response. Here is the formula
and how it is supposed to work.

=SUM('BDR Daily - Day 6'!
$I$160+$I$161+$I$163+$I$170+$I$171+$I$172+$I$174+$I$178+$I
$179+$I$180+$I$181+$I$188)

I have 35 days in a workbook all labled "BDR Daily - Day
1" through "BDR Daily - Day 35"

The formula doesn't work on any day I just happened to
use Page 6 as an example.

The above formula pulls into a daily sheet used for
reporting that day's activities to management.

Starting from I70 or $I$170 as it's known doesn't pull
any data from the other Excel sheets.

So, $I$170 pulls data from 6 individual sources but that
forumla works fine and the data appears in the box $I$170
pulls from but $I$170 is not passing the data to the
final report.

Sorry if this isn't clear. Please let me know if you
need any more detials or if I can explain it better?

Thanks.

Adam,

1. You need to specify the sheet for each cell. Otherwise the cell will come
from the sheet containing the formula.

2. The SUM function is not necessary, either in this formula or in the one
where you are specifying the sheets.

=SUM(I27+AI27+BI27+I75+AI75+BI75) is the same as

=I27+AI27+BI27+I75+AI75+BI75




--ron