Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Using SUM and VLOOKUP formula together in to fetch data from multiple cells?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2019, 10:42 AM
ArviLaanemets ArviLaanemets is offline Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Windows 8 Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Office 2016
Expert
  
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Here is a version with single formula (I used OP's 2nd table)
Attached Files
File Type: xlsx SumTest.xlsx (13.6 KB, 12 views)
Reply With Quote
  #2  
Old 01-17-2019, 09:25 PM
Bumba Bumba is offline Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Windows 7 32bit Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Office 2010
Novice
Using SUM and VLOOKUP formula together in to fetch data from multiple cells? 		 
Join Date: Jan 2019
Posts: 26
Bumba is on a distinguished road
Default
Thanks both xor and ArviLaanemets,
Do you mind explaining your respective codes?
Reply With Quote
  #3  
Old 01-17-2019, 10:18 PM
xor xor is offline Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Windows 10 Using SUM and VLOOKUP formula together in to fetch data from multiple cells? 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 explanation in the attached workbook.
Attached Files
File Type: xlsx Sum_Quarter_2.xlsx (41.7 KB, 12 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Keeping the source format when extracting data from multiple cells using Vlookup function praboos2001 Excel 6 11-15-2016 04:40 AM
Need a formula (possibly something like VLOOKUP) that will return multiple results. SilverUnicorn79 Excel 8 08-16-2016 01:34 PM
Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Need help with a VLOOKUP formula & two similar, yet non-identical columns of data. mikey386 Excel 1 12-18-2014 01:59 AM
Using SUM and VLOOKUP formula together in to fetch data from multiple cells? VLookup is giving me #N/A error, help with data or formula? ladygogo78 Excel 3 10-22-2012 12:28 AM
Using SUM and VLOOKUP formula together in to fetch data from multiple cells? Multiple VLOOKUP's checking multiple Cells OTPM Excel 11 05-23-2011 11:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:14 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