Getting the formula right

[highstream]

I'm trying to set up a cell that is the result of the following: Sum F77:F83 divided by sum D7783. Thus far I've yet to find a way without iterating each cell, but I know there must be. Ideas? Thanks,

 

[Amy @ German Pearls]

If I'm understanding you correctly, you can use:

=sum(f77:f83)/sum(d77:d83)

 

[highstream]

Hmm...For some reason that didn't work right for me this morning, at least with the sum sign. Now, it does with the text "sum," which I thought I tried too. Well, in any case it's now returning the (yellow) caution that adjacent cells are omitted. That's to be checked "ignore," right? Thanks,

 

[Amy @ German Pearls]

As long as those are the correct cells you're referencing just ignore that error.

 

[highstream]

Strange it gives that error. Just realized why I was having problems this morning: \ vs. / Thanks for you help.

 

[Amy @ German Pearls]

It tries to predict what formulas should be to help but it can't always understand what we're trying to do. Glad it's working for you.