Screen Shot 2017-05-22 at 2.57.23 PM.pngScreen Shot 2017-05-22 at 2.57.17 PM.png
I am trying to write a formula so I can get the correct quantities for my estimating sheet. I already wrote macros so when you click the button everything I need shows up in my "pole by pole take off" sheet. After that I need a formula to get those items and specific quantities to recognize the same items on the "material pricing list" sheet. I tried to get it using a countifs fn but I could only get it to recognize that there was one there not how many there were in the quantity section. I have it matching the part number and then I can't get it to produce the quantity needed. Thanks in advance! Let me know if this needs clarification because I feel like it doesn't make sense.
Bookmarks