User Profile
mwb014
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Trying to use one cell which includes multiple identifiers to obtain the pivot table value
Patrick2788 Not sure if this will work in my situation. Sometimes my identifier is just one number ( 10062 and sometimes my identifier has 2+ numbers. I need to pull the value of those numbers above from my pivot table which in time will add more PO numbers on the pivot and potentially to the identifiers as the Project manager issues them. The easiest option I have is to have a column per each PO and sum it that way, but I was trying to see if there was a way that everytime a new PO was issued and included in this file, it would be able to automatically sum the value of the PO with a formula. I do appreciate the help. The formula you provided might help me on a different file that I have and help simplify my current formula.736Views0likes0CommentsTrying to use one cell which includes multiple identifiers to obtain the pivot table value
Hello, I am currently trying to come up with a formula that sums from a pivot table using a sumif formula to get that value of certain POs. Some identifers are just one PO number which ends up summing correctly, but some identifiers have 2+ PO numbers and I cannot for the life of me get it to sum. The screen shot below is an example, the Per PO line should have a value since those POs are included in the pivot table. Also below is my current formula. =IF(AN545="No Po",0,SUMIF('PO Table'!$A$4:$A$29,'Daily Updates'!AN545,'PO Table'!$B$4:$B$29)) I have tried using some special characters but it is proving me with a value of zero. I have used the * in the past with one identifier, but it is not working with multiple identifiers in one cell. =IF(AQ545="No Po",0,SUMIF('PO Table'!$A$4:$A$29,"*"&AQ545&"*",'PO Table'!$B$4:$B$29)) Any help is greatly appreciated because I am very stuck and I am not sure what to do besides manually creating a column for each PO number and breaking it out that way, but that would extend my file by quite a bit.818Views0likes2CommentsFormula to either pull multiple values with an Hlookup or a substitute formula instead of an Hlookup
Hello everyone, I am trying to either update my hlookup, or come up with a different formula when pulling values. My file includes a tab that has all my general ledger accounts in one row and project managers update the cost by day based on invoices credit cards etc. I have a row where I sum the cost through a period of time and I have an hlookup formula (=HLOOKUP(A23,'Daily Updates'!$AG$5:$EG$7,3,0)) that pulls that value to a comparison sheet. When I receive the files there are times where the project managers add a new column with the same GL account to track it easier, but since there are now duplicates of the same number, the Hlookup only gives me the first column's value with that account number. My current process is to manually sum all values with that GL account and place it in the front of the first column to make sure the hlookup pulls that value to ensure I have all the cost, but I am wondering if someone can help me come up with a formula or a function that can help this process be less manual. I am currently using Microsoft 2016. All help is greatly appreciated!Solved1.2KViews0likes2Comments
Recent Blog Articles
No content to show