Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Length of Stay
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Length of Stay
Hi,
Try this =sumproduct((A2:A150="A")*(B2:B150))/countif(A2:A150,"A") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Georgeb123" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Length of Stay
=SUMIF(A1:A26,"A",B1:B26)/COUNTIF(A1:A26,"A")
or, if you have Excel 2007+ =AVERAGEIF(A1:A26,"A",B1:B26) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Georgeb123" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Average Length of Service | Excel Worksheet Functions | |||
Trying to calculate average call length | Excel Worksheet Functions | |||
Setting the Length of Time a File Can Stay Open | Excel Discussion (Misc queries) | |||
Calculate average of ratings as a function of length | Excel Worksheet Functions | |||
Validation length, Range length | Excel Discussion (Misc queries) |