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.
Last edited by ksymons22; 05-22-2017 at 03:33 PM.
Re: Function help!
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Hi and welcome to the forum
Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By tusharb in forum Excel Programming / VBA / Macros
Last Post: 05-13-2016, 12:43 AM
By jakopak in forum Excel Programming / VBA / Macros
Last Post: 11-02-2015, 05:58 AM
By mycroft in forum Excel Programming / VBA / Macros
Last Post: 04-08-2014, 05:46 AM
By msiddiq1208 in forum Excel Programming / VBA / Macros
Last Post: 01-15-2014, 11:40 PM
By Touch9713 in forum Excel Formulas & Functions
Last Post: 10-12-2013, 10:09 PM
By jano_rajmond in forum Excel General
Last Post: 03-21-2012, 11:22 AM
By giallofever in forum Excel General
Last Post: 03-20-2009, 01:29 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1