excel help

Copper Contributor



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






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


15 Replies


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.

Yes but there is problem , how to sum sales for each person


You can use SUMIF or SUMIFS to sum the sales per person.



and answer for this task should be name of person. So who has highest, second highest and third highers sales. Any ideas?


You can create a list of persons and sales and sort it descending on sales.

@HansVogelaar   I do not think it will work out, I need just one formula(see below)problem.PNG


You'll need to use a combination of INDEX and MATCH.

Could you please clarify it?


I think it's time you did some research yourself.

Do not worry that is what I have been doing for the last few hours
that is what I have been doing for the last couple of hours