SUMIF formula is not working?

Hello,

I am pretty inexperienced at more complex excel functions. I have been trying my best to create the attached spreadsheet, and hit a problem that I can not resolve.

In my February sheet, the formulas in cells L11:L13 are not functioning the way I was hoping.

I want to be able to obtain the sum of the total elapsed time based on the criteria in column E ("NC", "CS", "SA").

Hopefully, I have provided enough information on what I am intenting to accomplish.

Any help is very appreciated.

Thanks!

The formula in F11:

=TEXT(D11-B11, "h:mm")


Change to:

=D11-B11

and copy down.

Great, thank you!

Last question. If want to do the same function, but now include sums from other the similar cells, how would I do that?

Yes of course. So after making the corrections above, I got the result I wanted.

However, I would now like to a have all the total sum of the times from F2:G6, F11:F15, F20:F24, F29:F33 still qualified based on the criteria in column E ("NC", "CS", "SA"). So basically do the formula above, but have additional data/cells added to the formula.

Hopefully, I've done a good enough job describing what I'm looking for.

Thanks in advance,

Great! Everything seems to be working like I wanted.

Thanks for the help everyone.