• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index Match and Summing Query

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
 

Attachments

  • Index Query.xlsx
    169 KB · Views: 5
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
 

Attachments

  • Index Query.xlsx
    181.1 KB · Views: 0
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
 

Attachments

  • Index Query.xlsx
    182.6 KB · Views: 3
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
 

Attachments

  • Index Query.xlsx
    182.7 KB · Views: 3
Back
Top