Using SUMIF to pull text from another cell as range

[kong1802]

I'm using a SUMIF function to pull a number from a different sheet depending on the month. Each column is for a different month, so I will need it to pull February's data in February. Currently I have the following function:
=SUMIF('CPT Utilization'!C:C, "Average Pts Treated", 'CPT Utilization'!AD:AD)

For February, it will need to pull 'CPT Utilization'!AE:AE)

In a separate cell, I put a formula in that will populate 'CPT Utilization'!AE:AE when February is entered. The problem is I can't seem to figure out how to link this cell successfully in my original formula.



Thanks in advance for any guidance!

[xor]

See the attached.

Please come again if you need explanation.

[kong1802]

Originally Posted by xor

See the attached.

Please come again if you need explanation.

That works really well.

Thank you!