asked on

How do I use SUMIF to sum time cells based on two criteria?

Hello Experts,
I am trying to make a SUMIF formula work that is based on two criteria. I've attached a sample worksheet. Can you help?

Gary

SUMIF-Help-EE-2.xls

SiddharthRout

Gary you can use sumproduct to get your results for example

=SUMPRODUCT((A4:A25="Out, First")*(B4:B25))

Will sum durations where "activity" matches "Out, First"

Sid

ASKER CERTIFIED SOLUTION

KnutsonBM

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SiddharthRout

And for your condition 2 you can use

=SUMPRODUCT((A4:A25="Out, First")*(C4:C25>0)*(C4:C25))

Sid

SiddharthRout

Oh, I didn't see your reply KnutsonBM:

Sid

KnutsonBM

no problem, our response's aren't exactly the same, similar though, so whatever he chooses to go with that works best for him........

Brandon

KnutsonBM

wouldn't yours be summing column c though? i believe he wants column B summed............i think....

KnutsonBM

the other thing, without the *24 it brings back a response of .333333..., easily solved by reformatting the cell as well, or just multiplying by 24.........either way

SiddharthRout

>>>no problem, our response's aren't exactly the same,

Yeah :)

I just gave Garry two conditions like he wanted.

Sid

SiddharthRout

>>the other thing, without the *24 it brings back a response of .333333..., easily solved by reformatting the cell as well, or just multiplying by 24.........either way

Yeah. I reformatted the cell :)

Sid

garyrobbins

ASKER

When Experts compete, I win! I not only get fast results, but also helpful variations.

Great responses guys -- thank you.

Gary

SiddharthRout

I feel as if I have wasted my time on this thread...

Sid