|
| 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
May 17th, 2005, 12:22 AM
|
|||
|
|||
help with formula
How would you write a formula that subtracts qty in cell
c2,d3,e4,f5,g6,h7,I8 total rusults in J9 
|
|
#2
May 17th, 2005, 12:36 AM
|
|||
|
|||
|
Subtracts from what?
If you're subtracting all the other cells from C2, perhaps something like: J9: =SUM(C2,-D3,-E4,-F5,-G6,-H7,-I8) or, more compactly: J9: =-SUM(-C2,D3,E4,F5,G6,H7,I8) In article , wrote: How would you write a formula that subtracts qty in cell c2,d3,e4,f5,g6,h7,I8 total rusults in J9
|
|
#3
May 17th, 2005, 12:37 AM
|
|||
|
|||
|
Do you mean:
=-sum(c2,d3,e4,f5,g6,h7,I8) or maybe: =c2-sum(d3,e4,f5,g6,h7,I8) wrote: How would you write a formula that subtracts qty in cell c2,d3,e4,f5,g6,h7,I8 total rusults in J9 -- Dave Peterson
|
|
#4
May 17th, 2005, 12:47 PM
|
|||
|
|||
|
Dave & JE -
Is there a benefit to using SUM() instead of +/- for non-contiguous cells? You both recommended =-sum(c2,d3,e4,f5,g6,h7,I8) when, out of habit, I'd have used =c2-d3-e4-f5-g6-h7-I8 Just curious "Dave Peterson" wrote: Do you mean: =-sum(c2,d3,e4,f5,g6,h7,I8) or maybe: =c2-sum(d3,e4,f5,g6,h7,I8) wrote: How would you write a formula that subtracts qty in cell c2,d3,e4,f5,g6,h7,I8 total rusults in J9 -- Dave Peterson
|
|
#5
May 17th, 2005, 02:19 PM
|
|||
|
|||
|
Just a personal preference for me--assuming that the values in those cells is
non-text. But =sum() behaves differently when there is text in one of those cells. Duke Carey wrote: Dave & JE - Is there a benefit to using SUM() instead of +/- for non-contiguous cells? You both recommended =-sum(c2,d3,e4,f5,g6,h7,I8) when, out of habit, I'd have used =c2-d3-e4-f5-g6-h7-I8 Just curious "Dave Peterson" wrote: Do you mean: =-sum(c2,d3,e4,f5,g6,h7,I8) or maybe: =c2-sum(d3,e4,f5,g6,h7,I8) wrote: How would you write a formula that subtracts qty in cell c2,d3,e4,f5,g6,h7,I8 total rusults in J9 -- Dave Peterson -- Dave Peterson
|
|
#6
May 17th, 2005, 02:31 PM
|
|||
|
|||
|
The advantage of using SUM is that it ignores non-numeric arguments.
When I develop apps for clients, I find that a large number of users clear a cell using the spacebar. Using +/- operators give an error when that occurs. One could use validation, but many clients don't want to train themselves to use a different key. The disadvantage of using SUM is that function calls are generally less efficient than their corresponding math operations. In article , "Duke Carey" wrote: Is there a benefit to using SUM() instead of +/- for non-contiguous cells? You both recommended =-sum(c2,d3,e4,f5,g6,h7,I8) when, out of habit, I'd have used =c2-d3-e4-f5-g6-h7-I8
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
| Excel Formula | yuki | Worksheet Functions | 7 | September 28th, 2004 02:40 AM |
| Add to formula | Pat | Worksheet Functions | 16 | September 24th, 2004 03:38 PM |
| Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
Linear Mode
