Summing totals with 2 variables

Dina Miller

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.

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

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.