Hi Martin

You can use Sumproduct

Start here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Martin B" wrote in message ...
Hi Group

Hope you can help with this and appologies if its already been covered but I have a spreadsheet used to record the output from 4 production shifts over a number of weeks

Col A = week number
Col B = team (A,B,C,D)
Col C = Units per hour produced

The columns are named ranges i.e Col A is called "weeknum", Col B is called "Team" and Col C is called "unitsperhour"

What I need to be able to do is find the average number of units per hour for a given team and a given week so I think I'm after something along the lines of

countif(weeknum=10)and(team=B) to find the number of entries for team B in wk 10 and
sumif(weeknum=10)and(team=B),unitsperhour to add all the entries for team B in wk 10 to allow the average to be calculated.

Hope thats clear enough

Thanks in anticipation

Martin Bagshaw