# Average with sets of two criteria

Microsoft Office 2007 home and student
February 11, 2011 at 08:51:14
Specs: Windows Vista
 I have a spreadsheet set up to calculate total hours worked for each employee and how many sales were done - per week.I want to calculate the average number of sales per hour worked for the entire month.This is how the sheet is set up:Cells A7:A16 contain the employee namesColumn B & C contain the data for week 1 (B shows total hours worked and C shows total sales)Column D & E contain the data for week 2 (D shows total hours worked and E shows total sales)Column F & G contain the data for week 3 (F shows total hours worked and G shows total sales)Column H & I contain the data for week 4 (H shows total hours worked and I shows total sales)Column L & M contain the total data for the month (L totals hours (B+D+F+H) and M totals the sales (C+E+G+I) In Column N I want the average sales per hour worked. What formula would I use?

See More: Average with sets of two criteria

#1
February 11, 2011 at 11:18:57
 Why wouldn't the solution be anything other than the total hours divided by the total sales?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions