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 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
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 Excel-like 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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!