Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Terry
 
Posts: n/a
Default how do I write a formula for?

I want to add e2 thru e7 and e10 thru e14 together into a separate cell and
i just can't figure how to write the formula
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Terry

Like this

=SUM(E2:E7,E10:E14)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Terry" wrote in message
...
I want to add e2 thru e7 and e10 thru e14 together into a separate cell
and
i just can't figure how to write the formula



  #3   Report Post  
Terry
 
Posts: n/a
Default

Gosh Thaks Nick, I am no means a master and manage to get by and I was very
close to what you showed me
Terry

"Nick Hodge" wrote:

Terry

Like this

=SUM(E2:E7,E10:E14)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Terry" wrote in message
...
I want to add e2 thru e7 and e10 thru e14 together into a separate cell
and
i just can't figure how to write the formula




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Write formula to add "1" to each number in a column GrannyLib Excel Worksheet Functions 3 January 11th 05 07:09 PM
How do I write my formula to automatically regenerate a RAND () i. Regi Excel Worksheet Functions 1 December 8th 04 10:06 PM
How can I write an if-then formula for 0 or less than 0 in cell t. Baz1 Excel Worksheet Functions 1 November 30th 04 04:33 PM
How do I write a formula to subtract a # from a total ONLY if the. JP Excel Worksheet Functions 2 November 17th 04 12:32 AM
write a formula to sum cells on different pages of the same workb. Kestle Excel Worksheet Functions 1 November 8th 04 07:53 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"