ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell calculation (https://www.excelbanter.com/excel-discussion-misc-queries/160308-cell-calculation.html)

srain001

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

Peo Sjoblom

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




Gary''s Student

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


srain001

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