Hello guys,

Thanks in advance for your help, I'm learning a lot through this forum.

I already have this formula that counts how many cells I have that meet these 2 criterias.

=SUMPRODUCT(--(Table2[Milestones]="blabla"),--((Table2[Date]>0)))

But I want to have the Average number of days between all the dates that meet the criteria "blabla" and are not empty and all the dates that meet the criteria "lolo" and are not empty.

It has to be an Array formula because I have multiple times the Milestone "blabla" and the milestone "lolo".


Hope it'S clear, thanks a lot for your input.

Cheers.


Guillaume