| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell value in its own calculation | Excel Worksheet Functions | |||
| YTD calculation using same cell | Excel Worksheet Functions | |||
| Cell Calculation | Excel Worksheet Functions | |||
| How do I exclude a cell from an average calculation when the cell. | Excel Discussion (Misc queries) | |||
| Calculation within a Cell | New Users to Excel | |||
Linear Mode
