Formula - adding two columns based on a condition
I think I'm close but this is driving me crazy.
I have an event code column and two other columns where I am collecting participation data on Saturday and Sunday.
I would like to know the total participation for the weekend. The formula for just Saturday or just Sunday works
=SUMIF([Event Code]:[Event Code], "CL021718A", ([# Sat]:[# Sat]))
but I can't find the way to combine the two.
I had assumed I now had to use SUMIFS... here's what I've been trying...
=SUMIFS([Event Code]:[Event Code], "CL021718A", ([# Sat]:[# Sat]), ([# Sun]:[# Sun]))
Any insights would be so appreciated!
-Melissa
Comments
-
The way to accomplish this is to use simple math to add two countif formulas together. The following formula should do the trick -- if I titled your columns correctly.
=SUMIF([Event Code]:[Event Code], "CL021718A", [# Sat]:[# Sat]) + SUMIF([Event Code]:[Event Code], "CL021718A", [# Sun]:[# Sun])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!