sumif statement with date column

  • Thread starter Thread starter rsqrn
  • Start date Start date
R

rsqrn

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
 
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<>""))
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif function with a date range condition statement 4
SUMIFS with Dates 1
Sumif formula 4
Multiple critera with in a sumif statement 5
Sumif() with dates 10
Using SUMIFs on a changing Pivot Table - Help! 2
Sumproduct and Count If 1
Sumif comparing dates in criteria 1

Back
Top