Lookup text and calculate values in cells from columns in the same row

The formula I'm using for this is working, but it feels like it could be completed in an easier way.

I want to look up the text "Grand (Total)" from the Rows column then divide the numbers from the Audits and Findings columns in the same row.

Any suggestions on how I could shorten this formula?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

That is about as simplified as it gets unless you wanted to start working with helper columns.

All comments

Paul Newcome

That is about as simplified as it gets unless you wanted to start working with helper columns.

John Renney

Thanks for taking a look @Paul Newcome

Paul Newcome

Sure thing. 👍️

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.