G
Guest
How would you write a formula that subtracts qty in cell
c2,d3,e4,f5,g6,h7,I8 total rusults in J9
c2,d3,e4,f5,g6,h7,I8 total rusults in J9
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
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)
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)
D
Dave Peterson
Do you mean:
=-sum(c2,d3,e4,f5,g6,h7,I8)
or maybe:
=c2-sum(d3,e4,f5,g6,h7,I8)
=-sum(c2,d3,e4,f5,g6,h7,I8)
or maybe:
=c2-sum(d3,e4,f5,g6,h7,I8)
D
Duke Carey
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
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
D
Dave Peterson
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.
non-text.
But =sum() behaves differently when there is text in one of those cells.
J
JE McGimpsey
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.
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.