Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cummulative sum against Condition
I would like to calculate the sum of column B if the cells against that on
column A satisfy my condition. In column A i have about 8 to 10 types of entries with some quantites against each entry in column B. The sum shall be calulated in a separate sheet say 'sheet 2'. Every time i enter a value in column A & B in 'Sheet 1'. The corresponding sum shall be updated against that type of entry in 'sheet 2'. Vlookup only gives the vakue against one type but does not consider if the same type appear later in that column. Please suggest a suitable formulae for this calulation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cummulative graph | Excel Discussion (Misc queries) | |||
Cummulative Return | Excel Worksheet Functions | |||
Cummulative | Excel Worksheet Functions | |||
cummulative sum | Excel Worksheet Functions |