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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!