Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
How do I write a formula to subtract a # from a total ONLY if the. | Excel Worksheet Functions | |||
write a formula to sum cells on different pages of the same workb. | Excel Worksheet Functions |