Formula Help

Question

HI all,

I have a sheet that has a column with total Jan Work hours available  and i have another column that names the production division that those Jan work hours belong to.

I was to create a column formula in a new column that provides the total Jan work hours available for Structural Shop Team Hours

I think it is a sumIf formula but I am stuck on the formatting after

=sumif([Jan Workhours]:[Jan Workhours], (then how do I only return the value if the Production Division column is Structural Shop Team?

Bassam Khalil · Accepted Answer

Hi @BESP10,

please try the following formula:

=SUMIF([Production Division]:[Production Division], "Structural Shop Team", [Jan Workhours]:[Jan Workhours])

Bassam Khalil · Accepted Answer

That's Good News @BESP10 don't hesitate to call if you need any help,