# Formula help

Options
✭✭✭✭✭

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")

Jacque Smith

Project Controls, MSR-FSR

Tags:

• ✭✭✭✭✭✭
Options

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")

Thanks,

Aravind GP| Principal Consultant

Atturra Data & Integration

M: +61493337445

E:Aravind.GP@atturra.com

W: www.atturra.com

• ✭✭✭✭✭✭
Options

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")

Thanks,

Aravind GP| Principal Consultant

Atturra Data & Integration

M: +61493337445

E:Aravind.GP@atturra.com

W: www.atturra.com

• ✭✭✭✭✭
Options

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

Jacque Smith

Project Controls, MSR-FSR

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!