![]() |
|
#1
|
|||
|
|||
![]()
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! |
#2
|
|||
|
|||
![]()
See the attached.
Please come again if you need explanation. |
#3
|
|||
|
|||
![]()
That works really well.
Thank you! |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
![]() |
Haha88 | Excel | 8 | 12-28-2016 09:15 PM |
![]() |
Skumby | Excel | 2 | 07-28-2016 10:39 PM |
![]() |
rick10r | Excel | 1 | 07-05-2016 12:07 PM |
![]() |
Haha88 | Excel | 6 | 10-29-2015 03:26 AM |