Index Match and Summing Query

[Ecel Dumbo]

hello,

Can you please refer attached spreadsheet and advise what is the rror in my indiex match formula and also suggest a formula for the particular summing in columns AL and AM

Thanks

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[Ecel Dumbo]

Thanks Nebu. Pivot table would do the trick and would serve the purpose. I was looking in to more of a formula. Should do the job for now. Thanks heaps. Can you also please suggest a summing formula based on what i have mentioned in the "sheet 1" tab

 

[Nebu]

Hi:

Formula in yellow cells, its an array formula , I have just done it for one customer just to show you that it is possible through a formula, but I would recommend you to use a Pivot.

Thanks

 

[Ecel Dumbo]

Thanks Nebu. Can you also please suggest me a formula for columns AL and AM in "Result" tab. This is a column totaling up months based on conditions

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Ecel Dumbo]

Thank you very much NEBU. Did the trick