I want to add more that 30 noncontiguous cells in Excel
You can also use multiple area references:
=SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99))
The above formula contains 3 arguments. Each set of (...) is a single
argument.
--
Biff
Microsoft Excel MVP
"Egozite" wrote in message
...
I have a string of noncontiguous cells in excel that I need the total of,
but
I can't enter more that 30 using the sum function
|