Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of 2 Months basis
Dear All,
Please help as follows: A B C Row1 288 - Row2 288 288 Row3 279 279 Row4 288 288 - Row5 279 279 279 Row6 288 288 288 I would like to sum every column A,B and C with two month basis (Where Column A, starting sum the number from row1, while column C, starting sum the number from row5). Purpose, i want to know with ROW() function, then +2 for range then sum those two number. Or please help any better solution. TIA... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of 2 Months basis
How do you distinguish the months? If you give an example of what you're
trying to do, and the result you expect, someone may be able to help. Andri wrote: Dear All, Please help as follows: A B C Row1 288 - Row2 288 288 Row3 279 279 Row4 288 288 - Row5 279 279 279 Row6 288 288 288 I would like to sum every column A,B and C with two month basis (Where Column A, starting sum the number from row1, while column C, starting sum the number from row5). Purpose, i want to know with ROW() function, then +2 for range then sum those two number. Or please help any better solution. TIA... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NPV on a Quaterly Basis | Excel Discussion (Misc queries) | |||
Define Basis | Excel Worksheet Functions | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
converting months to years and months??? | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) |