Sumifs error formula when summing duration time

Graeme Baxter

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

DKazatsky2

Hi @Graeme Baxter,

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

Bassam Khalil

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:

Graeme Baxter

@Bassam Khalil

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?

DKazatsky2

Hi @Graeme Baxter,

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

Graeme Baxter

@DKazatsky2

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

Graeme