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..)
David James Sarah
Q1
Q2
Q3
Q4
2. 10. Who had the first, second and third highest sales by names?
3. . What percentage is each sale for all those made in the same year?
Thank you for any help
Tom
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.
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))
