Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGEIF AND SUMIF AND COUNTIF
I have a column with open date (B), column with closed date (C), column with
count of days opened (D). I need to calculate the average number of days each were opened in the 1st, 2nd, 3rd and 4th quarter of the fiscal year as well as the entire fiscal year. I have been physicallly typing in each cell reference that has an opening date int he first quarter, but would like to be able to say SUM COLUMN D ONLY IF COLUMN B "=10/01/2004" also "<=12/31/2004". THEN COUNTIF COLUMN B ONLY IF "=10/01/2004" ALSO "<=12/31/2004" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an AVERAGEIF function. | Excel Worksheet Functions |