• 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.

Look UP certain values and then combine the rest in to one cell

E

Ecel Dumbo

Member
Hi,


Please refer the attached. I need a formula to look up certian value and then in the following cell I would like to have to have the total of rest of the amounts for that specific criteria.


http://speedy.sh/5jjAq/Excel-Query.xls


Any help will be greatly appreciated. Thanks


Excel Dumbo
 
Have you thought of using a Pivot Table? It will organize your data nicely and makes it easy to retrieve data.


Have a look and see if this is something like what you're after:


http://speedy.sh/yCCYx/Excel-Query-with-pivot-chart.xls
 
Thanks maku.exactly what i wanted. THis will defintely serve the purpose. Just because I am very interested in formaula, i was wondering if we can do it without the pivot table
 
Yes...you can. see attached in tab Results (2). You will see it is identical to the results tab that used a pivot table. You can use the index function and sumifs to find and tally your data. Happy Thanksgiving.


http://speedy.sh/yCaYx/Excel-Query-without-pivot-table.xls
 
You must log in or register to reply here.
Back
Top