Hi Team,
I've been having issues getting this one sorted, I'm on Excel 365 now. I have been trying to take the amount from A2:A8 with the below formula criteria,using the below formula i thought it would work, however i believe that excel is having issues with using a number as a wild card. However the Number at the start is all i care about as there could be multiple different numbers starting with a 1 , 2, 3, 4, etc and these come at different lengths as well.
=SUMIFS($A$2:$A$8, $B$2:$B$8, "2*", $C$2:$C$8, "P")
^ Above is looking to be placed in G fields.
Any suggestions would be appreciated.
I've been having issues getting this one sorted, I'm on Excel 365 now. I have been trying to take the amount from A2:A8 with the below formula criteria,using the below formula i thought it would work, however i believe that excel is having issues with using a number as a wild card. However the Number at the start is all i care about as there could be multiple different numbers starting with a 1 , 2, 3, 4, etc and these come at different lengths as well.
=SUMIFS($A$2:$A$8, $B$2:$B$8, "2*", $C$2:$C$8, "P")
^ Above is looking to be placed in G fields.
Any suggestions would be appreciated.