Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum only selected cells
Hi everyone,
I have some data for last 1 year starting from C3:C14 , I enter no. of months in Cell C1 ( example 7) in cell C2 i want the sum of only 7 months ( entered in Cell C1), How can i achieve this. Chetan J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum only selected cells
try this
=SUM(OFFSET(C3,0,0,C1,1)) "Chetu" a écrit dans le message de ... Hi everyone, I have some data for last 1 year starting from C3:C14 , I enter no. of months in Cell C1 ( example 7) in cell C2 i want the sum of only 7 months ( entered in Cell C1), How can i achieve this. Chetan J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
Macro to take selected cells times a selected cell | Excel Programming |