How to Sum if field contains the same text

Jen K.

Sum.JPG

Hello,

Could you please assist me in developing a formula that will display a grand total if a certain criteria is met? What I'm looking for is highlighted in the table's Sum field.

Thank you

Carson Penticuff

Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.

=SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])

Carson Penticuff

Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.

=SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])

Jen K.

This worked! Thank you for your help!