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
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!