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

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!