Formula Help

BESP10

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

Hi @BESP10,

please try the following formula:

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

Bassam Khalil

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

Bassam Khalil

Hi @BESP10,

please try the following formula:

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

BESP10

thank you @Bassam Khalil that works

Bassam Khalil

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