![]() |
Cell calculation
Hello,
I'm trying to find a way to calculate non-consecutive cells, sort of like a sum, but since the cells are not consecutive, I don't know the formula for what I want. Ex: I'm trying to calculate the values of cells of D22 and D28. This column has a lot of figures between those cells, but I don't want to include them in this calculation. Thanx Srain |
Cell calculation
=SUM(D22,D28)
or =D22+D28 you never posted what kind of calculations you want to do, I just assumed SUM -- Regards, Peo Sjoblom "srain001" wrote in message ... Hello, I'm trying to find a way to calculate non-consecutive cells, sort of like a sum, but since the cells are not consecutive, I don't know the formula for what I want. Ex: I'm trying to calculate the values of cells of D22 and D28. This column has a lot of figures between those cells, but I don't want to include them in this calculation. Thanx Srain |
Cell calculation
=SUM(D22,D28)
-- Gary''s Student - gsnu200748 "srain001" wrote: Hello, I'm trying to find a way to calculate non-consecutive cells, sort of like a sum, but since the cells are not consecutive, I don't know the formula for what I want. Ex: I'm trying to calculate the values of cells of D22 and D28. This column has a lot of figures between those cells, but I don't want to include them in this calculation. Thanx Srain |
Cell calculation
Thanx. Exactly what I needed!
Cheers! Srain "Peo Sjoblom" wrote: =SUM(D22,D28) or =D22+D28 you never posted what kind of calculations you want to do, I just assumed SUM -- Regards, Peo Sjoblom "srain001" wrote in message ... Hello, I'm trying to find a way to calculate non-consecutive cells, sort of like a sum, but since the cells are not consecutive, I don't know the formula for what I want. Ex: I'm trying to calculate the values of cells of D22 and D28. This column has a lot of figures between those cells, but I don't want to include them in this calculation. Thanx Srain |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com