# Sumifs error formula when summing duration time

edited 03/05/24

HI, I have a metric sheet where it is comparing to see person exists on another sheet and if so calculate the durations assigned against all their tasks.

I get an #UNPARSEABLE in the formula that I cant figure out. Can anyone advise?

=SUMIFS({Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, >1)

This is my target sheet

This is my source sheet

Thanks

• ✭✭✭✭✭✭

Try changing your formula to this: =SUMIFS({Michael Johnson duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

I am assuming you are failing on {Duration} because you don't have that as a reference.

Hope this helps,

Dave

• ✭✭✭✭✭✭

Hi@ Graeme Baxter,

please try the following formula :

```=SUMIFS({Duration}, {Assign To}, [IT Personnel w no Email]@row, {Duration}, @cell > 1)
```

the following is the database sheet :

and this is the target sheet:

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• Appreciate your time.

I did as you suggested but I get a #INVALID REF

=SUMIFS({Duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

Do I have something wrong here?

• ✭✭✭✭✭✭

Try changing your formula to this: =SUMIFS({Michael Johnson duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

I am assuming you are failing on {Duration} because you don't have that as a reference.

Hope this helps,

Dave

• That worked. Thank you so much for your help. Much appreciated.

Graeme

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!