Sum formula with criteria

[Gonney]

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.

 

[Fluff]

I'm on Excel 365 now

In that case I suggest you change your profile to show this.

How about

=sum(filter($A$2:$A$8,(left($B$2:$B$8,1)="2")*($C$2:$C$8="P")))

 

[Gonney]

In that case I suggest you change your profile to show this.

How about

=sum(filter($A$2:$A$8,(left($B$2:$B$8,1)="2")*($C$2:$C$8="P")))

Updated in profile .

Thank you for all the support Fluff <3 you got me heading down the right road <3.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Gonney]

You're welcome & thanks for the feedback.

Is there a chance you could please have a look at : Sum formula with criteria - Letters not working

I thought I had this all sorted but any time i use letters it does not add them to the calculation <3..