SUMIF using a text condition

Question

Level 1

4 points

SUMIF using a text condition

Hello folks. I am trying to use a conditional; SUMIF function in Numbers 3.6.1. OSX Yosemite. I have a spreadsheet with a range of values such as *health", 'Industry" etc and against each one is a % value. I am used to the approach of sumif ((range with condition) (condition - e.g. =health) (range of values)). I can only find guidance on using numerical or YES/NO type binary conditions in the Apple help.

much thanks

Liza

iPhone 5s, iOS 9.0.2

Posted on Jan 29, 2016 9:14 AM

Reply

Answer 1

SGIII

Level 8

37,532 points

Jan 29, 2016 9:24 AM in response to LizaJ60

Are you looking for something like this?

SG

Reply

Answer 2

SGIII

Level 8

37,532 points

Jan 29, 2016 11:51 AM in response to LizaJ60

Glad it worked. Note that you can put the wildcard in front too if, say, "health" is in the middle of a string (text) and not at the beginning. You always need the quotes around a string in a formula; otherwise Numbers can get confused and think it's the name of a table or something else. Thanks for the green tick!

SG

Reply

Answer 3

LizaJ60 Author

Level 1

4 points

Jan 29, 2016 10:02 AM in response to SGIII

Perfect! I used =Health* instead of the quotes. Much appreciated. Liza

Reply