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

[Bumba]

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

{=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?

[Pecoflyer]

Hi
as external links are notoriously unsafe , that not all members can access them, please post your file on the forum. Thank you

[Bumba]

Originally Posted by Pecoflyer

Hi
as external links are notoriously unsafe , that not all members can access them, please post your file on the forum. Thank you

Hi Pecoflyer,
I've attached the sample file and removed the external download link

[xor]

What about the attached?

[ArviLaanemets]

Here is a version with single formula (I used OP's 2nd table)

[Bumba]

Thanks both xor and ArviLaanemets,
Do you mind explaining your respective codes?

[xor]

See explanation in the attached workbook.

[ArviLaanemets]

Here you go!