You could easily write a UDF in VBA; or you could do something like:
=A2-SUM(A3:A40)
Now I wonder how long it would take you to decide which one you'd choose
Ron....... <g
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ron Rosenfeld" wrote in message
...
On Sat, 19 Feb 2005 09:31:02 -0800, Darius
wrote:
I think that MS EXCEL 2003 should have a simpler formula to subtract
numbers
versus it's current one that requires a minus sign after every cell
reference. The formula should be similar to the function that's
performed
with the "sum" function. An example of this forula would look like this:
=diff(A2:A40), instead of it's current syntax which is
=A2-A3-A4............
This would allow for the subtraction of a wider range of cells in less
time.
You could easily write a UDF in VBA; or you could do something like:
=A2-SUM(A3:A40)
--ron
|