Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable totalling
Hi,
A table having months as columns and products in rows. I need to get the cumulative total for the month specified. For example if I give month as 2, it should add the first two columns and if I give months as 6 it should add the first six columns. I tried using offset, but it didn't work properly. Thanks for help. -- Cheers ! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable totalling
Assuming the number is in A7, and we start at column 2, here is an example
=SUM(INDEX(2:2,,2):INDEX(2:2,,1+A7)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sena" wrote in message ... Hi, A table having months as columns and products in rows. I need to get the cumulative total for the month specified. For example if I give month as 2, it should add the first two columns and if I give months as 6 it should add the first six columns. I tried using offset, but it didn't work properly. Thanks for help. -- Cheers ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My SUM function is totalling to 0 | Excel Worksheet Functions | |||
totalling | Excel Discussion (Misc queries) | |||
Totalling in excel | Excel Discussion (Misc queries) | |||
Totalling Collumns | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |