Counting values in a column if different column shows certain value
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 MultiSelect column and the column that counts the instances of the MultiSelect 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 MultiSelect and Value columns), I'm open for such a solution as well.
THANK YOU FOR YOUR HELP WITH THIS!
Martin
Best Answer

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
Answers

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

Roy, this is really so simple when looking at it now.
I'm new to Smartsheet formulas and was thinking too much of an Excellike formula and of course that would not work.
THANK YOU!

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:
Help Article Resources
Categories
Check out the Formula Handbook template!