Formula help

jacquedale

I am needing to pull from the main sheet:

If contractor is X, and it is X date how many "daily weld count"

I need to put together a graph that shows contract X has # welds per day. I have managed to count how many entries there are for a given date but not the # in the "daily weld count" column.

Here is the formula I used so far

=COUNTIFS({Weld Count Log Range 1}, [Primary Column]@row, {Weld Count Log Range 2}, [Column7]@row, {Weld Count Log Range 4}, "Field Welds")

AravindGP

Hi @jacquedale

You will need to change the formula to SUMIFS to get the total sum for your criteria. =SUMIFS([Daily Weld Count]:[Daily Weld Count], Contractor:Contractor, "Contractor name", Date:Date, "your date criteria", [Shop/Field Weld]:[Shop/Field Weld], "Field Welds")

AravindGP

Hi @jacquedale

You will need to change the formula to SUMIFS to get the total sum for your criteria. =SUMIFS([Daily Weld Count]:[Daily Weld Count], Contractor:Contractor, "Contractor name", Date:Date, "your date criteria", [Shop/Field Weld]:[Shop/Field Weld], "Field Welds")

jacquedale

@AravindGP You are a life saver! This worked perfectly. Thank you so much.