Counting time on projects with variables.

Frederik Soerensen

Hello.

I am trying to create a formula that counts the amount of time an open project has taken. I am also trying to segregate it by priority (high, medium, low).

I have tried using a sumif formula like this:

=SUMIFS({Service Range 1} - TODAY(); {Service Range 6}; "HIGH"; {Service Range 5}; 0

*** clarifications

*"Service" is a sheet I am referencing

**Service Range 5 is set to 0, it is because it is a checkmark box (I assumed unchecked boxes = 0)

How can I fix this, and where did I go wrong?

Thank you in advance.

Paul Newcome

You would have to have the difference calculated on the source sheet. Then you would reference this range as the range to sum followed by your range/criteria sets.