Formula ideas

So here goes;

sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN}

Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match

I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??

Find more posts tagged with

Formulas

Accepted answers

Stacy Meadows

I overcome it ...

I used =sumifs({Oct22}, {RevPC}, postcode@row, {RevPN}, name@row)

seems to work thank you :)

All comments

Paul Newcome

Are you able to provide some screenshots for reference?

Stacy Meadows

I overcome it ...

I used =sumifs({Oct22}, {RevPC}, postcode@row, {RevPN}, name@row)

seems to work thank you :)

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.