Formula help

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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

AravindGP

Hi @jacquedale

jacquedale

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.