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
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!