Results 1 to 3 of 3

Thread: Help with Multi-criteria lookup and auto sum values
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help with Multi-criteria lookup and auto sum values

    I have a very unique situation. I am in the mechanical estimating field and do material take-offs on isometric drawings for clients. Each material take off is based on a set of material specifications supplied by the client. As I do the material take-off, there may be several hundred drawings that have the same materials. I need excel to look at the data list I have in my take-off and sum like material quantities and then delete the duplicate rows. I believe I am on the right track but there are flaws I cannot figure out. That is my first inquiry. My second inquiry is how to look the material specifications up based on criteria I enter as I do my take off. I plan to enter the material specifications in an excel array. As I enter the material excel will look in the array and return the correct material specification it must return. Any help would be appreciated. I will enclose a material spec and an example auto combine take-off I started playing with if needed.


    Thanks,

  2. #2
    New Member
    Join Date
    Oct 2014
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with Multi-criteria lookup and auto sum values

    Hello,

    please provide an example so we can assist you

    Thank you

  3. #3
    New Member
    Join Date
    Feb 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with Multi-criteria lookup and auto sum values

    How can I attach my Excel File and material spec example?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •