Forum Discussion

mwb014's avatar
mwb014
Copper Contributor
Jun 01, 2023

Trying 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 su...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Jun 01, 2023

mwb014 

 

You could arrange this a few ways.

 

Here are some examples:

=SUM(SUMIFS(val,colors,{"Blue","Yellow"}))

Or

=SUMIF(colors,"blue",val)+SUMIF(colors,"yellow",val)

 

 

mwb014's avatar
mwb014
Copper Contributor
Jun 05, 2023

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.

 

 

Resources