Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif statement with date column
Help,
I'm trying to create a tracking form with a column filled with dates ie: C6:C26 I would like to look for a range of dates by quarter and count data in another column ie: E6:E26. I can't seem to set a date range in the C column and get it to count. I'm a novice so please be gentle. Thanks, Frank |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif statement with date column
count data in another column ie: E6:E26.
What exactly do you want to count in that column? Cells that are not empty? Try this... Use cells to hold your date boundaries: A6 = lower date boundary B6 = upper date boundary Then: =SUMPRODUCT(--(C6:C26=A6),--(C6:C26<=B6),--(E6:E26<"")) -- Biff Microsoft Excel MVP "rsqrn" wrote in message ... Help, I'm trying to create a tracking form with a column filled with dates ie: C6:C26 I would like to look for a range of dates by quarter and count data in another column ie: E6:E26. I can't seem to set a date range in the C column and get it to count. I'm a novice so please be gentle. Thanks, Frank |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif statement with date column
Hmmm...
The subject line says "sumif" but in the post you said "count". If you do want a conditional sum try this. Still using cells to hold your date boundaries... =SUMIF(C6:C26,"="&A6,E6:E26)-SUMIF(C6:C26,""&B6,E6:E26) -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... count data in another column ie: E6:E26. What exactly do you want to count in that column? Cells that are not empty? Try this... Use cells to hold your date boundaries: A6 = lower date boundary B6 = upper date boundary Then: =SUMPRODUCT(--(C6:C26=A6),--(C6:C26<=B6),--(E6:E26<"")) -- Biff Microsoft Excel MVP "rsqrn" wrote in message ... Help, I'm trying to create a tracking form with a column filled with dates ie: C6:C26 I would like to look for a range of dates by quarter and count data in another column ie: E6:E26. I can't seem to set a date range in the C column and get it to count. I'm a novice so please be gentle. Thanks, Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif function with a date range condition statement | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
sumif statement | Excel Discussion (Misc queries) | |||
Date Format Inside of a SUMIF Statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |