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.....
Since this is homework, I'll just provide a hint: you can use the SUMIFS function to sum the sales of a specific trader in a specific quarter, and also to sum all sales in the same quarter. The quotient of the two sums will return the percentage.
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.