starting from O2 to O10, i have this:
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
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