SUMIF vs. SUMIFS

Options
Pattyk
Pattyk
edited 12/09/19 in Smartsheet Basics

I am looking to add the total hotel night stays from multiple labels in a single criteria column. This is my formula, but it results in "0" which is incorrect: 

=SUMIFS(NIGHTS10:NIGHTS38, AFFILIATION10:AFFILIATION38, "Researcher", AFFILIATION10:AFFILIATION38, "RAN", AFFILIATION10:AFFILIATION38, "ECD awardee")

 

NIGHTS:NIGHTS = # of hotel night stays

AFFILIATION:AFFILIATION = location of labels (criteria)

SUMIF or SUMIFS? What am I missing in the formula above if using SUMIFS?

Patty

Comments