Help on formula SUMIF using two validations. Validate Date and Name.

ovelzone

Hi all,

I am trying to extract individual Branch weekly sales from the table below,

I am using the formula below but not able to make it work? Any ideas would be much appreciated.

=SUMIFS([Sold Date]:[Sold Date], WEEKNUMBER(@cell) = 1,(AND((Branch:Branch, Names@row,(TRTotal:TRTotal)))

Many Thanks in advance.

Find more posts tagged with

Accepted answers

Genevieve P.

Hey @ovelzone

Here's the formula version:

=SUMIFS(TRTotal:TRTotal, [Sold Date]:[Sold Date], WEEKNUMBER(@cell) = 1, Branch:Branch, Names@row)

Cheers,

Genevieve

All comments

ovelzone

I realised i can use the Sheet filter, but just wondering if there is a formula that i can use without filter as i will be creating separate sheets for different Branches. Thanks.

Genevieve P.

Hey @ovelzone

Here's the formula version:

=SUMIFS(TRTotal:TRTotal, [Sold Date]:[Sold Date], WEEKNUMBER(@cell) = 1, Branch:Branch, Names@row)

Cheers,

Genevieve

ovelzone

@Genevieve P. Thank you so much.. it works. Have a great weekend!

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.