Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average with 2 criteria including month
In Excel 2000, I'm trying to create a formula whereby it finds case types
(ex: ABC) that close in a particular month (ex. January) and calculates the average length those cases were open. What's wrong w/ my formula? I get the #VALUE! displayed. I've also tried entering it as an array formula w/ the same result. =AVERAGE(IF((J17:J1500="ABC")*(MONTH(I17:I1500)=1) ,F17:1500)). Column J contains the case types, column I has the close dates (ex. 1/15/07), and col F calculates the # of days a case is open based on the open date (col G) & close date (col I). Now I know that I can use Autofilters for the the case types & close dates and the =SUBTOTAL(1,F17:F1500) formula, but I want to have the values for each of these months readily available. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill days of the month (not including weekends) | Excel Worksheet Functions | |||
How do I count frequency based on 2 criteria (including month) | Excel Worksheet Functions | |||
Average range including blank cells: #DIV/0! | Excel Worksheet Functions | |||
in excel, how do i get an average without including the zeros? | Excel Worksheet Functions | |||
How do I average a column without including zeros | Excel Discussion (Misc queries) |