I need to count the number of times a user changed job functions and I'm working based on the data that has been loaded in an SQL database. Below you'll find the example of the layout.

Line# Filename...User........Ent........Crt

1.........File1.........John........69.........0
2.........File1.........John........0..........117
3.........File1.........John........196.......0
4.........File1.........John........60.........0
5.........File1.........John........76.........0

6.........File2.........John.........0.........174
7.........File2.........John.........0.........95

8.........File3.........John.........0.........110
9.........File3.........John.........178.....0
10.......File3.........John.........0.........70
11.......File3.........John.........0.........25

So if I did a count of the files it would = 3 that's not correct...
if I did a count of the Entered it would = 5 incorrect...
same mis-calculation for Correcting...

The number I should get is 7. 1 (for line1) + 1 (for line 2) + 1 (for 3,4,5) + 1 (for 6,7) + 1 (for 8) + 1 (for 9) + 1 (for 10,11)

For the life of me I can not figure out how to write this calculation into a crystal reports syntax. Any Help would be GREATLY appreciate!!