I have dates in one column, names in the next column and counts in other column.
I want the formula to count the individuals as per the date. 1. For example, on 11/1/2014, I want Sum of Kiran's error. 2. For example, on 11/1/2014, I want Count of Kiran's error.
Date Processed by Total Errors
11/1/2014 Kiran 1
11/1/2014 Ajay 2
11/1/2014 Kiran 2
11/1/2014 Ajay 1
11/2/2014 Kiran 1
11/2/2014 Ajay 2
11/2/2014 Kiran 2
11/2/2014 Ajay 1
11/3/2014 Kiran 1
11/3/2014 Ajay 2
11/3/2014 Kiran 2
11/3/2014 Ajay 1