|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 14th, 2009, 07:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Simple calc not working as expected - what am I missing?
This is probably something so simple, but I can't figure it out, can someone
help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4  4) The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue. I know there are ways I can work around this, but am curious why this doesn't seem to be working? 
|
|
#2
September 14th, 2009, 07:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
Try it like this:
=A4-SUM(B4 4)-- Biff Microsoft Excel MVP "MarianneS40" wrote in message ... This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4 4)The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue.I know there are ways I can work around this, but am curious why this doesn't seem to be working?
|
|
#3
September 14th, 2009, 07:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
Hi
Try this: =A4-SUM(B4 4)Regards, Per "MarianneS40" skrev i meddelelsen ... This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4 4)The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue.I know there are ways I can work around this, but am curious why this doesn't seem to be working?
|
|
#4
September 14th, 2009, 07:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
=A4-SUM(B4
4)-- Gary''s Student - gsnu200903
|
|
#5
September 14th, 2009, 07:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
Hi MarianneS40
the formula should be : =A4-sum(B4 4)click yes below, if it helps "MarianneS40" wrote: This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4 4) The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue. I know there are ways I can work around this, but am curious why this doesn't seem to be working?
|
|
#6
September 14th, 2009, 08:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
How do you get the original formula to work - doesn't it give you a value
error? "T. Valko" wrote: Try it like this: =A4-SUM(B4 4)-- Biff Microsoft Excel MVP "MarianneS40" wrote in message ... This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4 4)The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue.I know there are ways I can work around this, but am curious why this doesn't seem to be working?
|
|
#7
September 14th, 2009, 09:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
How do you get the original formula to work
doesn't it give you a value error? Depends on where the formula is entered. The formula is in D5 So, what's happening is A4 minus D4 (200-10) = 190 Try putting the formula in E5 then you'll get #VALUE! The reason it returns a number when entered in cell D5 is because the formula is entered in a column that directly intersects a cell in the referenced range, D4. -- Biff Microsoft Excel MVP "Brad" wrote in message ... How do you get the original formula to work - doesn't it give you a value error? "T. Valko" wrote: Try it like this: =A4-SUM(B4 4)-- Biff Microsoft Excel MVP "MarianneS40" wrote in message ... This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4 4)The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue.I know there are ways I can work around this, but am curious why this doesn't seem to be working?
|
|
#8
October 12th, 2009, 05:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple calc not working as expected - what am I missing?
Hi all,
Thank you for the responses - Missed all of this because Outlook stuck the reply email into my Junk Email folder ... And accessing this forum is for some reason extremely cumbersome - IE crashing, logging in, can't find my topic, then can find it, it's not a good experience. Meanwhile with regard to the formula - I appreciate everyone giving me the correct formula; however, I don't understand why the original formula wouldn't work, as it follows all the 'rules' of the SUM function.... This seems like an Excel shortcoming to me. And I am imagining that this worked in previous versions, but could definitely be mistaken there. Anyway, thanks for all the help. Cheers, Marianne "T. Valko" wrote: How do you get the original formula to work doesn't it give you a value error? Depends on where the formula is entered. The formula is in D5 So, what's happening is A4 minus D4 (200-10) = 190 Try putting the formula in E5 then you'll get #VALUE! The reason it returns a number when entered in cell D5 is because the formula is entered in a column that directly intersects a cell in the referenced range, D4. -- Biff Microsoft Excel MVP "Brad" wrote in message ... How do you get the original formula to work - doesn't it give you a value error? "T. Valko" wrote: Try it like this: =A4-SUM(B4 4)-- Biff Microsoft Excel MVP "MarianneS40" wrote in message ... This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row: A4 B4 C4 D4 200 50 60 10 The formula is in D5 and looks like this: =SUM(A4-B4 4)The answer SHOULD be 80, but the formula says 190. I've also tried =SUM(A4-(B4 4)), same issue.I know there are ways I can work around this, but am curious why this doesn't seem to be working?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
