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.

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

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!