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 names
Column 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

Report •

#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


Ask Question