| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cumulative sum on Condition (Horizontally) Part-2
Hi,
Another help required from the same excel sheet, my sheet goes in the month format upto "n" (example current month Mar-07), then how to pick up the values in the financial year (Apr-Mar is a year). The formula (=SUMPRODUCT(($A$3:$A$5=N3)*($B$1:$I$1<=N1)*(B2:I2 =N2)*($B$3:$I$5))) what i am using advised by our experts (is caliculating apr 05-mar 07 instead of apr 06-mar 07. Excuse me if i have not given the scenario exactly. Thanks to "Toppers", who really helped me in this issue. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cumulative sum on Condition (Horizontally) | Excel Worksheet Functions | |||
| Filter horizontally? | Excel Worksheet Functions | |||
| Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
| adding part of a function on condition. | Excel Worksheet Functions | |||
| Autofilter horizontally? | Excel Discussion (Misc queries) | |||
Threaded Mode
