Building a Sum If Statement

I'm trying to build a SumIfs statement that calculates the number of hours by type (Sick, Vacation, Personal) by employee ID. I'm able to do a simple SimIf for the total, but struggling with how to break it down by sick type.

This is the statement I'm using and its resulting in an incorrect argument:

=SUMIFS({Employe Absence Info 4.1.20 Range 1}, =ID647, AND({Employee Absence Info 4.1.20 Range 1}, ="Sick"), {Employee Absence Info 4.1.20 Range 1})

Any help would be appreciated!

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

For SUMIFS, the range to sum actually comes first and then is followed by your range/criteria sets.

=SUMIFS({Range to sum}, {ID Range}, "ID647", {Type Range}, "Sick")

Kasey Bernard

Actually, I was able to fix it, the correct statement is this: =SUMIFS({Employe Absence Info 4.1.20 Range 6}, {Employe Absence Info 4.1.20 Range 1}, =ID647, {Employee Absence Info 4.1.20 Range 1}, ="Sick")

Thank you for your help @Paul Newcome!!

All comments

Kasey Bernard

Also tried this: =SUMIF({Employe Absence Info 4.1.20 Range 1}, =ID647, AND({Employee Absence Info 4.1.20 Range 1}), ="Sick", {Employe Absence Info 4.1.20 Range 6})

Paul Newcome

For SUMIFS, the range to sum actually comes first and then is followed by your range/criteria sets.

=SUMIFS({Range to sum}, {ID Range}, "ID647", {Type Range}, "Sick")

Kasey Bernard

Thank you, that is tricky! So I've tried that, and now it's returning a zero value, when it should be producing a total. Here's the formula: =SUMIFS({Employe Absence Info 4.1.20 Range 6}, {Employe Absence Info 4.1.20 Range 1}, ID647, {Employee Absence Info 4.1.20 Range 1}, "Sick")

Any suggestions?

Kasey Bernard

Thank you for your help @Paul Newcome!!

Paul Newcome

Glad you were able to get it working, and happy to help! 👍️

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.