Using SUM and VLOOKUP formula together in to fetch data from multiple cells?

Bumba · #1 01-16-2019, 11:22 PM

Say I have an excel file which looks like below:

How do I get values of all the columns in below table fields Quarter-1, Quarter-2, Quarter-3, Quarter-4 in one go, where Quarter-1 is the sum of the values from Jan--2018 to Mar--2018 in the above table, Quarter-2 is the sum of the values from Apr--2018 to Jun--2018 etc.

Now, I've written the below formula's in Quarter-1, Quarter-2, Quarter-3, Quarter-4 respectively

Code:

{=SUM(VLOOKUP([@Name],Table1[[#All],[Name]:[Dec--2018]],{2,3,4},0))}

{=SUM(VLOOKUP([@Name],Table1[[#All],[Name]:[Dec--2018]],{5,6,7},0))}

{=SUM(VLOOKUP([@Name],Table1[[#All],[Name]:[Dec--2018]],{8,9,10},0))}

{=SUM(VLOOKUP([@Name],Table1[[#All],[Name]:[Dec--2018]],{11,12,13},0))}

But can I do this using a single formula and not need to change the column index array values in every column?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Need help with a VLOOKUP formula & two similar, yet non-identical columns of data.	mikey386	Excel	1	12-18-2014 01:59 AM
VLookup is giving me #N/A error, help with data or formula?	ladygogo78	Excel	3	10-22-2012 12:28 AM
Multiple VLOOKUP's checking multiple Cells	OTPM	Excel	11	05-23-2011 11:18 AM