Using SumIfs to search for a text string

jsah_VFC · 05/17/19

I'm basically trying to search for X text within my Email column to average out the monthly data. Can someone please advise what i'm missing cause it's driving me insane, haha. I know it's gotta be something simple.

unable to search for text.png

Andrée Starå · 05/17/19

Hi,

The range has to be the same.

Try something like this.

=SUMIF(Email1:Email10; $Primary3; Delivered1:Delivered10)

The same version but with the below changes for your and others convenience.

=SUMIF(Email1:Email10, $Primary3, Delivered1:Delivered10)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

jsah_VFC · 05/18/19

what a life saver!!! Where in the world is this documentation?

Andrée Starå · 05/18/19

Lifesaver! Wow! Thanks!

Happy to help!

Look here for documentation/help:

https://help.smartsheet.com

https://help.smartsheet.com/functions

Best,

Andrée

Using SumIfs to search for a text string

Comments

Categories