Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using SUMIF to pull text from another cell as range Using SUMIF to pull text from another cell as range
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2017, 08:29 AM
kong1802 kong1802 is offline Using SUMIF to pull text from another cell as range Windows 8 Using SUMIF to pull text from another cell as range Office 2000
Novice
Using SUMIF to pull text from another cell as range 		 
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
  #2  
Old 02-07-2017, 10:37 AM
xor xor is offline Using SUMIF to pull text from another cell as range Windows 10 Using SUMIF to pull text from another cell as range Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
See the attached.

Please come again if you need explanation.
Attached Files
File Type: xlsx kong1802.xlsx (17.2 KB, 11 views)
Reply With Quote
  #3  
Old 02-07-2017, 11:04 AM
kong1802 kong1802 is offline Using SUMIF to pull text from another cell as range Windows 8 Using SUMIF to pull text from another cell as range Office 2000
Novice
Using SUMIF to pull text from another cell as range 		 
Join Date: Feb 2017
Posts: 3
kong1802 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
See the attached.

Please come again if you need explanation.
That works really well.

Thank you!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using SUMIF to pull text from another cell as range Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
Using SUMIF to pull text from another cell as range Sumif with various conditions in the same range Haha88 Excel 8 12-28-2016 09:15 PM
Using SUMIF to pull text from another cell as range Sumif based on date range Skumby Excel 2 07-28-2016 10:39 PM
Using SUMIF to pull text from another cell as range If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
Using SUMIF to pull text from another cell as range Sumif with multiple sum range Haha88 Excel 6 10-29-2015 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft