Hi Guys,

I’m unsure whether this is at all possible but ideally I would like a sum of a cell to be determined by what drop-down box is selected in another cell… i.e. a different sum range for each drop-down option. Is this do-able?

I have read about array formulas and have managed to get it to work separately E.g. {=SUM(SUMIF(G44,F29,D28:D30))} + {=SUM(SUMIF(G45,F29,D28+D30) (I want to exclude D29 in this instance) but cannot combine the two options as one formula so that it uses either depending on the drop-down selected (F29 being the cell with the data validation, G44 and G45 being the two drop down options).

What’s the best way to work this?

Many thanks,

Becky