Sum if match formula

Hello,

I am looking for a fairly complicated formula (I think).

I have two sheets: 1) IW POD and 2) Root Bushing Repair Tracker

on sheet 2, I have a column named "Actual Execution Hours"

In that column, on sheet 2, I need to sum the hours on sheet 1 in column "Total Actual Hours" IF these two columns match on both sheets - Turbine number and Blade number.

Both sheets have a column named "Total Actual Hours"

Find more posts tagged with

Accepted answers

Paul Newcome

You would use something like this:

=SUMIFS({Sheet 1 Actual Hours}, {Sheet 1 Turbine Number}, @cell = [Turbine Number]@row, {Sheet 1 Blade Number}, @cell = [Blade Number]@row)

If that doesn't work, screenshots would be helpful.

All comments

Paul Newcome

You would use something like this:

=SUMIFS({Sheet 1 Actual Hours}, {Sheet 1 Turbine Number}, @cell = [Turbine Number]@row, {Sheet 1 Blade Number}, @cell = [Blade Number]@row)

If that doesn't work, screenshots would be helpful.

Amanda MedinaIW

Thank you Paul! Worked like a charm :)

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.