Timesheet needs hours to repeat, have used Sum if to get total

Ok Guys this formula works great but I need the hours in G column to repeat if the are not a 1 code. Appreicate your help. criterial sumtest.xlsx




=80-SUM(IF(($A$2:$A$69<>1)*($B$2:$B$69=$B24),$G$2:$G$69,""))

Hi patsyhixon,

May be below formula can helpL-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

Couldn't get it to work, it places #value where my total needs to go, but it does place the hours correctly.

Hi patsyhixon,

See the attachment where I have used the logic if column A is not 1 then G2 value should display, else the calculated result.

Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome patsyhixon. . .
And thanks for the star.

Regards,
DILIPandey

<click on below star if this helps>