Counting values in a column if different column shows certain value

Martin_M

Hi all,

this is my first question to the community.

Here's the dilemma I've been braking my brain about for a while...

I have a sheet and would like to add a Sheet Summary Field that does the following:

If in column "Name" the name is "John", add all values together found in column "Value" for John. Same for Chris and Linda.

Hopefully this makes sense.

I already have the Multi-Select column and the column that counts the instances of the Multi-Select column.

All I would need is the formula for the Sheet Summary Field, that adds up all numbers in column "Value", if the name in column "Name" is John. Same for Chris and Linda (in my example).

In my example, John had 4 items altogether, Chris had 3 and Linda had 2.

If there's a smarter/simpler solution than what I've done (adding the Multi-Select and Value columns), I'm open for such a solution as well.

THANK YOU FOR YOUR HELP WITH THIS!

Martin

Shimanta Roy

Hi Martin, you can use the following formula to count the values for John:

=SUMIF(Name:Name, "John", Value:Value)

You can do the same for others by just changing the names

Shimanta Roy

Hi Martin, you can use the following formula to count the values for John:

=SUMIF(Name:Name, "John", Value:Value)

You can do the same for others by just changing the names

Martin_M

https://community.smartsheet.com/discussion/comment/330879#Comment_330879

Roy, this is really so simple when looking at it now.

I'm new to Smartsheet formulas and was thinking too much of an Excel-like formula and of course that would not work.

THANK YOU!

Martin_M

Hi Roy,

THANK YOU AGAIN for your help with the above!!

Today, I posted another question – should you be "bored" (by any chance) and not know what to do..., here it is:

https://community.smartsheet.com/discussion/104180/how-to-setup-a-form-for-multiple-entries-that-update-the-same-row