Average Length of Stay

[Georgeb123]

Column A is Funding Source: "A" or "T"
Column B is Days of Stay calculated from check-out date minus check-in date.
How to calculate Column C as Average Length of Stay for "A"s?

 

[Ashish Mathur]

Hi,

Try this

=sumproduct((A2:A150="A")*(B2:B150))/countif(A2:A150,"A")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Bernard Liengme]

=SUMIF(A1:A26,"A",B1:B26)/COUNTIF(A1:A26,"A")
or, if you have Excel 2007+
=AVERAGEIF(A1:A26,"A",B1:B26)
best wishes