adding more than 30 agruments to a formula

[alexh]

Is there a way to simply add more than 30 cells that are not i
consecutive order

 

[Jason Morin]

Yes - here are 2 possibilities:

http://tinyurl.com/ypm4h

HTH
Jason
Atlanta, GA

 

[TKT-Tang]

Please study SUMIF in the Help File.

Regards.

 

[TKT-Tang]

Please refer to the following post :-


Regards.

 

[David McRitchie]

Unfortunately
does not point to the thread only to one posting, which
doesn't help much for those using Outlook Express, and
Internet Explorer, but

The following Google Groups link will point to the thread
and includes the message-id shown in your link, with
a few changes for $ being converted to %24
it takes about 12 hours for Google to slurp up newspostings.
http://google.com/[email protected]

But the point TKT-Tang is trying to make please post
in only one place. It is also a good idea to search Google
Groups for answers before posting.
http://www.mvps.org/dmcritchie/excel/xlnews.htm