Trying to divide specific cells in one column by specific cells in another column in Summary Sheet.

Hello, I'm trying to divide cells in one column by cells in another column. After reviewing several similar questions I created this formula:

=SUM([SOR - # of Users Activated]72:[SOR - # of Users Activated]75 / SUM[SOR - # of Users Ordered]72:[SOR - # of Users Ordered]75)

This of course is not working, Could you advise if this can indeed be done and if so how I should change my formula, it is returning 'Invalid Operation'

Thanks!

Find more posts tagged with

Accepted answers

All comments

Joel Turlington

Correction: This is the formula I created

=SUM([SOR - # of Users Activated]72:[SOR - # of Users Activated]75 / SUM([SOR - # of Users Ordered]72:[SOR - # of Users Ordered]75))

Paul Newcome

Just a misplaced closing parenthesis...

=SUM([SOR - # of Users Activated]72:[SOR - # of Users Activated]75) / SUM([SOR - # of Users Ordered]72:[SOR - # of Users Ordered]75)

You want

=SUM() / SUM()

You had

=SUM( / SUM())

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.