Hi

I have a spreadsheet with two sheets

Sheet One is a number of columns with various information and is feed from a SharePoint site , one column is Dept

The second sheet is will be a Summary sheet and initially I want for to list the number of depts ie

IE

Dept A - 16
Dept B - 7

and so on

Once that is sorted I hope ot do basic reporting for each dept using countif


Regards

John Berman