Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I set up a formula that consists of a sum on page 1 + a sum on
page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?
 
hi
thank you for your information but when i do that (which is makes total
sense now that i think about it) ..i write the formula as
=sum(week1:week5!a8)
because we named the pages "week"
after i finish the formula it says something like #NAME!*? and tells me that
the name for "week1" is unrecongnizable.
any thoughts
thanks
 
Funny, I just tested with a sheet named week1 and a sheet named week5.
Perhaps you have spaces or a leading or trailing space?
 
Thank You I figured it out and changed the names to the sheets with no spaces!
Thank you so much!! This post board has helped me out so much!
 
I just read your response to a formula question and you seem pretty
knowledgeable. I have 3 columns: Goal, Actual and Base. I am trying to find
a formula that will compare the amounts in both columns and post the correct
amount in Base.
If the amount in actual is more than the amount in goal then base = goal,
but if actual is less than goal, then the base is actual.

I can't quite get the formula for this. Do you have any clues for me?

Thanks

Donna
 
You're missing a condition...

What if Goal is equal to Actual?

Goal = 100
Actual = 100

What happens in that case?
 
Let Goal in in A1, Actual in B1
In the corresponding Base cell:
=IF(B1>A1, A1, B1)
read as If (actual greater than base) then give me Goal, else give be Actual

Of course, this =MIN(A1,B1) does the same thing

But as Biff asks what if they are the same? If they are both 4 then either
formula will give 4
If you want something more complex please let us know
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
 
I have the same issue, How would I set up a formula that consists of a sum
on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on
page 5,
but the numbers are not all in the same cell. Please help
 
I have multiple lines that will require the same type of data, how can I
include those calculations in the formula?
 
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 
Back
Top