Subtract command?

kinkyparamour · Feb 23rd, 2002, 08:33 PM

Hello,

Is there a command like sum which will subtract the values in a range of cells?

Thank you,
Denny

Feb 23rd, 2002, 08:50 PM

Why not use Sum(A1,-A2) format?
I can't find Subtract in Excel

kinkyparamour · Feb 23rd, 2002, 09:20 PM

sum(a1-a2)is good but I want to do a1:a20. Any ideas besides a1-a2-a3 and so.......

Denny

[ This Message was edited by: kinkyparamour on 2002-02-23 20:22 ]

pilot · Feb 23rd, 2002, 09:51 PM

This should work. Assume subtracting A2:A20 from A1.

=A1-SUM(A2:A20)

kinkyparamour · Feb 23rd, 2002, 10:13 PM

That works great. So simple, why didn't I think of it?

Thanks again,
Denny

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 23rd, 2002, 08:33 PM	#1
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Hello, Is there a command like sum which will subtract the values in a range of cells? Thank you, Denny

Feb 23rd, 2002, 08:50 PM	#2
Guest Posts: n/a	Why not use Sum(A1,-A2) format? I can't find Subtract in Excel

Feb 23rd, 2002, 09:20 PM	#3
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	sum(a1-a2)is good but I want to do a1:a20. Any ideas besides a1-a2-a3 and so....... Denny [ This Message was edited by: kinkyparamour on 2002-02-23 20:22 ]

Feb 23rd, 2002, 09:51 PM	#4
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	This should work. Assume subtracting A2:A20 from A1. =A1-SUM(A2:A20)

Feb 23rd, 2002, 10:13 PM	#5
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	That works great. So simple, why didn't I think of it? Thanks again, Denny