Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore calculation when criteria exceeds 12
I have a worksheet labelled Early Adopter Scheme whereby the cells in column
F contains a start date, column G calculates the number of months between the start date and today(), and column L contain a SUMIF formula, referencing a worksheet labelled OCR (in the same workbook). The data in the OCR worksheet will be updated on a monthly basis. I would like the SUMIF formula in column M to continue performing the calculation where the value in column G (the number of months column) does not exceed 12. When the corresponding cell in column G does exceed 12, i.e. 12 months, the end of the monitoring period is over and we are no longer interested in any additional business Is there any way of doing this? - allowing the calculation to perform until the end of the period? Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore calculation if text | Excel Worksheet Functions | |||
Median calculation and ignore zeros | Excel Discussion (Misc queries) | |||
calculation to ignore a 0 (zero) value | Excel Worksheet Functions | |||
Ignore errors when calculation average of multiple ranges | Excel Worksheet Functions | |||
Can a calculation ignore text if it occurs in formula's cell range | Excel Worksheet Functions |