Solved

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

Posted on 2014-03-31
338 Views
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?

0
Question by:Fritz Paul
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 51

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 39968464
Hi

Enter this Array formula with Ctrl-Shift Enter

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

Regards
0

Author Closing Comment

ID: 39968629
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month4 days, 23 hours left to enroll