Hi,

Please explain why the answer is 3.33. I think 4 of 11 in your list are ABC
so 4/11 =36.36% or with this formula

=COUNTIF(B1:B11,"abc")/COUNTA(B1:B11)

You don't explain the relevance of the dates.

Mike

Mike

"Kashyap" wrote:

I have 2 column as below and I want to calculate the average number of days
ABC occurs.. In this case it should be 3.33

Col A Col B
01-Apr ABC
01-Apr DBA
01-Apr ABC
03-Apr GRT
05-Apr HTA
05-Apr JYU
08-Apr ABC
08-Apr GRT
08-Apr HTA
10-Apr JYU
11-Apr ABC