Hi,
I have excel sheet Sheet1(data is spreaded on whole where data is like....

Activity Number Date1 Date2 Date3 Date4 Date 5 Date6
AN1 3 3
AN2 4 2
AN1 8
AN3 3
AN4
AN2 1 1
AN3 2
.
.
.
In sheet 2 Sheet2 I want to display data like....
Activity Number Total number
AN1 14
AN2 8
AN3 5 i.e total number for a specific activity .

How can I do this?