SUMIFS with sheet references.

Richard Lucas

Hello,

I've got this formula working like this.

=SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation")

However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count.

=SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL / Sick")

I've tried the same with other criteria and it seems to be just this one.

Find more posts tagged with

Formulas

functionality

Accepted answers

Jeff Reisman

I suspect it's the special character "/" in your criteria. Change your values and remove the slash, and change the formula to match, and see how it works then.

Richard Lucas

Changed the / to - and it worked. Must not like the /.

All comments

Jeff Reisman

I suspect it's the special character "/" in your criteria. Change your values and remove the slash, and change the formula to match, and see how it works then.

Paul Newcome

You would also want to ensure that the data in the sheet matches your criteria to include the spaces on either side of the slash. Upper vs lower case doesn't matter, but everything else needs to match.

Richard Lucas

Changed the / to - and it worked. Must not like the /.

Jeff Reisman

@Richard Lucas Glad it worked for you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.