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