SUMIF with Wildcard.

[srizki]

The request is to create a formula in column E of the tab named "Compare (roll up)". The formula should be designed to look up a value in column A and match the corresponding text on sheet PGL, Column A. It should then sum up the values in column G that correspond to the matched text. However, there is a problem where the formula adds up similar information. For instance, it sums up values for 111_cash and 11_cash. Therefore, the original formula needs to be corrected. The current formula being used is: =SUMIF(PGL!A:A,"*"&'COMPARE (ROLLUP)'!$25,PGL!$G:$G)
A correction is required to fix this issue.

Thank you!

 

[KOKOSEK]

"*" any sign.
"?" one sign
"??" 2 signs
etc.
So, "??_cash" summarise 11_cash and "???_cash" summarise 111_cash.

Book1
	B	C	D
3	111_cash	100	149
4	11_cash	50	101
5	111_cash	1
6	11_cash	99
Sheet1

Cell Formulas
Range	Formula
D3	D3	=SUMIFS(C:C,B:B,"??_cash")
D4	D4	=SUMIFS(C:C,B:B,"???_cash")

 

[srizki]

"*" any sign.
"?" one sign
"??" 2 signs
etc.
So, "??_cash" summarise 11_cash and "???_cash" summarise 111_cash.

Book1
	B	C	D
3
Sheet1

 

[srizki]

Thank you for your reply. 111_cash and 11_cash just an example,, there is more to this, may be I should add a sample here.