Sumif() function if the criteria is a text formula.

I have a table as below and want to use the sumif function to sum the percentages if the category in the left column starts with "LOCAL".

I have tried among others
=SUMIF($A$8:$A$15,"""LEFT(A8,5)="&"""LOCAL"""&"""",$B$8:$B$15)
but I can't make it work.

Anyone can?

Table for sumif()
Fritz PaulAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi

Enter this Array formula with Ctrl-Shift Enter

=SUM((B8:B15)*(LEFT(A8:A15,5)="LOCAL"))

Open in new window


Regards
0
 
Fritz PaulAuthor Commented:
Thanks, I have clean forgotten about array formulas. I had to go read up on them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.