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.....
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?
Do you have any hints for 2. tasks?
