Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Scenarios
I am trying to set up a formula to allow five variables to be aggregated (or
not)when they are switched on or off. e.g. Apples Pears Oranges Peaches Strawberries Yes Yes No Yes No Sales 500 330 200 199 54 Costs -30 -44 -180 -99 -30 Profit 470 286 20 100 24 I want to set the formula up so that Apples, Pears and Peaches would be aggregated in the above example. I can't seem to do this through IF as there are too many outcomes. Similarly, SUMIF works on the above, however I have weekly data for each of the above fruit and SUMIF doesn't work if I put time intervals in. This seems to be a pretty basic modelling query and I'm reasonably experienced, but it has got me totally stumped! Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Scenarios | Excel Worksheet Functions | |||
calculating multiple scenarios | Excel Discussion (Misc queries) | |||
IF statement - multiple scenarios | Excel Worksheet Functions | |||
IF statement with multiple scenarios. | Excel Discussion (Misc queries) | |||
How to do if/then formula with multiple scenarios. | Excel Discussion (Misc queries) |