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
Check out the Formula Handbook template!