Forum Discussion
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.....
but how to sum quarters since there is just date
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))
- Thanks I got it.
Do you have any hints for 2. tasks?Check out the RANK function.
- Yes but there is problem , how to sum sales for each person