Summing totals with 2 variables

I am trying to sum the amount of time it takes a specific individual to complete a certain task. I am trying to determine the best formula to use to accomplish this. I have been using SUMIF but not sure how to get it to work with two variables

My worksheet has 3 columns: Name, Task, Minutes

I need to identify the person (Name) and then the Task (i.e. process paperwork) and then how much time they are spending on that task.

No matter what I try - I keep getting #unparseable.

Any help would be greatly appreciated.

Find more posts tagged with

Formulas

Support

Accepted answers

David Tutwiler

You could try SUMIFS:

=SUMIFS(Minutes:Minutes, Name:Name, "Person's Name", Task:Task, "Example Task")

This will sum the Minutes Column if the Name = Person's Name and the Task = Example Task.

Dina Miller

Using the same SUMIFS formula, how do I select a date range - for example the month of November or the month of October?

Genevieve P.

Hi @Dina Miller

Try adding in the MONTH Function as your criteria, with = a number to represent the month (ex. 11 is November):

[Date Column]:[Date Column], MONTH(@cell) = 11

Note that with the MONTH function it's good to wrap it in an IFERROR in case the column has blank cells in it.

IFERROR(MONTH(@cell), 0) = 11

Try this:

=SUMIFS(Minutes:Minutes, Name:Name, "Person's Name", Task:Task, "Example Task", [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = 11)

Cheers!

Genevieve

All comments

David Tutwiler

You could try SUMIFS:

=SUMIFS(Minutes:Minutes, Name:Name, "Person's Name", Task:Task, "Example Task")

This will sum the Minutes Column if the Name = Person's Name and the Task = Example Task.

Dina Miller

Using the same SUMIFS formula, how do I select a date range - for example the month of November or the month of October?

Genevieve P.

Hi @Dina Miller

Try adding in the MONTH Function as your criteria, with = a number to represent the month (ex. 11 is November):

[Date Column]:[Date Column], MONTH(@cell) = 11

Note that with the MONTH function it's good to wrap it in an IFERROR in case the column has blank cells in it.

IFERROR(MONTH(@cell), 0) = 11

Try this:

=SUMIFS(Minutes:Minutes, Name:Name, "Person's Name", Task:Task, "Example Task", [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = 11)

Cheers!

Genevieve

Dina Miller

Hi @Genevieve P - Thank you - this worked. I appreciate the help!

Genevieve P.

No problem at all! I'm 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.