for pre-2007 Excel:
|Click Data, click Pivot Table, Next,
In the box that opens up, specify a cell to the right of the data base, with a blank column in between
Click Layout and drag Rounded Jobsat into both Row and Data
In Data, click on "Sum of Rounded Jobsat" and change it to "Count"