View Single Post
 
Old 02-07-2017, 08:29 AM
kong1802 kong1802 is offline Windows 8 Office 2000
Novice
 
Join Date: Feb 2017
Posts: 3
kong1802 is on a distinguished road
Default Using SUMIF to pull text from another cell as range

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!
Reply With Quote