## Forum Discussion

tomas395

May 04, 2022Copper Contributor

# excel help

Hi, Could anyone help me with following tasks using just one excel formula? (dataset below) 1.Percentage of quarter's sales made by each trader. (for instance DavidĀ“s sales for Q1.....

tomas395

Copper Contributor

but how to sum quarters since there is just date

HansVogelaar

May 04, 2022MVP

tomas395 You need to specify the date range twice in the SUMIFS formula. For example, Q1 of 2013 is from January 1, 2013 to March 31, 2013.

=SUMIFS(date_range, ">="&DATE(2013,1,1), date_range, "<="&DATE(2013,3,31))

- tomas395May 04, 2022Copper ContributorThanks I got it.

Do you have any hints for 2. tasks?- HansVogelaarMay 04, 2022MVP
Check out the RANK function.

- tomas395May 04, 2022Copper ContributorYes but there is problem , how to sum sales for each person