Using SUMIFS with CONTAINS

bstormer

Hi --

I'm a newbie trying to build a SUMIFS formula that counts numbers in an attendance row based on the type of event and fiscal year. I've been able to set up the SUMIF with the CONTAINS, but adding an additional criterion is returning UNPARSEABLE. Here's the one that works:

=SUMIF([Event Name]:[Event Name], CONTAINS("Basics", @cell), [Total Attendance]:[Total Attendance])

And here's the one I'm trying to create:

=SUMIFS([Event Name]:[Event Name], CONTAINS("Basics", @cell),[Fiscal Year]:[Fiscal Year], ("FY 21", @cell),[Total Attendance]:[Total Attendance])

Thanks in advance!

Andrée Starå

Hi @bstormer

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

bstormer

Took me most of the day but I figured it out. Here's what I did if others run into a similar issue:

=SUMIFS([Total Attendance]:[Total Attendance], [Fiscal Year]:[Fiscal Year], "FY 21", [Event Name]:[Event Name], CONTAINS("Basics", @cell))

Andrée Starå

Hi @bstormer

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!