Using SumIfs to search for a text string

jsah_VFC

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.

Andrée Starå

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

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

Andrée Starå

Lifesaver! Wow! Thanks!

Happy to help!

Look here for documentation/help:

https://help.smartsheet.com

https://help.smartsheet.com/functions

Best,

Andrée