Average Length of Stay

G

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?
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate average values for 100 records in the shortest way? 5
Format column widths from one table to a separate table on same page 1
Dealing with the error: unable to filter on excel hc home school 0
How to use/create code in MS Word to calculate age? 0
Formula to fill cells based on Date of Arrival and Date of Departure 1
countifs Function not giving desired result with date criteria 2
Sumproduct in matrix means 3
Please help me choose a product for the task 2

Top