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

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

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