dynamic sum

[daveyc18]

starting from O2 to O10, i have this:

FIE

FIR

RP

CMC

CMF

MLC

PSR

UPG

FIM

then i have this formula

=SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O2)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O3)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O4)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O5)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O6)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O7)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O8)+SUMIFS('raw data'!$K:$K,'raw data'!$E:$E,O10)

in column O, new categories could be added

im curious if there was a dynamic sum formula? ie., if i add another category in column O, the sum formula would dynamically pick it up

there must be a better way to add this info than the SUMIFS formula in here

 

[Jeffrey Mahoney]

Please try this:
=SUM(SUMIFS('raw data'!K:K,'raw data'!E:E,Sheet1!O2:O10))

 

[daveyc18]

Please try this:
=SUM(SUMIFS('raw data'!K:K,'raw data'!E:E,Sheet1!O2:O10))

perfect....replaced o210 with a dynamic named range to make the formula dynamic...thanks!