Solved

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

Posted on 2014-03-31
2
338 Views
Last Modified: 2014-04-01
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()
0
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39968464
Hi

Enter this Array formula with Ctrl-Shift Enter

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

Open in new window


Regards
0
 

Author Closing Comment

by:Fritz Paul
ID: 39968629
Thanks, I have clean forgotten about array formulas. I had to go read up on them.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

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.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question