ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i add numbers in nonadjacent cells? (https://www.excelbanter.com/excel-worksheet-functions/81032-how-do-i-add-numbers-nonadjacent-cells.html)

Bob

how do i add numbers in nonadjacent cells?
 

--
Bob

Peo Sjoblom

how do i add numbers in nonadjacent cells?
 
Any pattern like every third row or something? Also are there numbers in the
cells in-between, if not you can use

=SUM(Range) since sum will ignore text, otherwise use

=SUM(A1, B5, S2 etc)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Bob" wrote in message
...

--
Bob




All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com