badsham777
New Member
- Joined
- Oct 30, 2017
- Messages
- 2
I do the below SUMIFS to get SUM of value that meet the criteria and working fine.
=SUMIFS('book1.xlsx'!$G:$G,'book1.xlsx'!$B:$B,D2,'book1.xlsx'!$D:$D,"*"&G2&"*",'book1.xlsx'!$E:$E,H2)
The problem is now for column G (as bolded) has become text and I just want the formula to display the text result that meet the criteria as in the SUMIF.
Can anyone help me on this?
=SUMIFS('book1.xlsx'!$G:$G,'book1.xlsx'!$B:$B,D2,'book1.xlsx'!$D:$D,"*"&G2&"*",'book1.xlsx'!$E:$E,H2)
The problem is now for column G (as bolded) has become text and I just want the formula to display the text result that meet the criteria as in the SUMIF.
Can anyone help me on this?