Using SUMIF with Dynamic Arrays to sum column totals

[Matt7777777777]

I am trying to use a sumif with a sheet that has been set up with dyanmic arrays (see below image) I need to sum each column based on the flags "A,B or C". Is anyone able to suggest a formula that will spill and allow me to do this?

 

[bebo021999]

Try with SUMIF.

 

[Matt7777777777]

Try with SUMIF.

I am using SUMIF?

 

[bebo021999]

You are summing each column, aren't you?
With " I need to sum each column based on the flags "A,B or C". ", what exactly is your desired result?

 

[Matt7777777777]

You are summing each column, aren't you?
With " I need to sum each column based on the flags "A,B or C". ", what exactly is your desired result?

Did you see the attached picture? I am wanting to use sumif or alternative formula in conjunction with the dynamic array. I.e the formula should spill after being input. However, the standard sumif function does not spill. I need a workaround for this.

 

[bebo021999]

Is P&L range dimension fixed? from row 25 to 46?
Possible to 50, or 100?
Tell us which array is dynamic

 

[Matt7777777777]

Is P&L range dimension fixed? from row 25 to 46?
Possible to 50, or 100?
Tell us which array is dynamic

P&L Range can be fixed. All components are currently built on dynamic arrays so the model period and entire model will extend and contract based on a single input.

 

[Scott R]

cell I52,
=SUMIF(F25:F46, F52, OFFSET(I25:I46,, SEQUENCE(, COLUMNS(I15#), 0)))