sumproduct count with date

S

SteveDB1

Howdie all.
I'm trying to do a sumproduct that looks only at the fact there is a date
value in a cell.
I thought that I could use DATE(,,) but that didn't work.
My final goal will be to do a count of my total elements with dates only.
I.e., I have 2 columns, one has codes, and the other has dates.
thus far I've tried:
=sumproduct((CritRng1="Code")*(CritRng2=DATE(,,)))
=sumproduct((CritRng1="Code")*(CritRng2=IsNumber()))
=sumproduct((CritRng1="Code")*(CritRng2=value()))
=sumproduct((CritRng1="Code")*(CritRng2=IsNumber(value(cell#))))
And I cannot use DATE because it won't allow me just general dates; I need
to provide specific dates.
Value() didn't work.

What can I use to check if a cell has contents? and build a count function
off of that?
The actual contents don't matter in the second array of my sumproduct.
This is for a 2003 user so I cannot use countifs

Thank you.
Best.
SteveB.
 
G

Glenn

SteveDB1 said:
Howdie all.
I'm trying to do a sumproduct that looks only at the fact there is a date
value in a cell.
I thought that I could use DATE(,,) but that didn't work.
My final goal will be to do a count of my total elements with dates only.
I.e., I have 2 columns, one has codes, and the other has dates.
thus far I've tried:
=sumproduct((CritRng1="Code")*(CritRng2=DATE(,,)))
=sumproduct((CritRng1="Code")*(CritRng2=IsNumber()))
=sumproduct((CritRng1="Code")*(CritRng2=value()))
=sumproduct((CritRng1="Code")*(CritRng2=IsNumber(value(cell#))))
And I cannot use DATE because it won't allow me just general dates; I need
to provide specific dates.
Value() didn't work.

What can I use to check if a cell has contents? and build a count function
off of that?
The actual contents don't matter in the second array of my sumproduct.
This is for a 2003 user so I cannot use countifs

Thank you.
Best.
SteveB.
Click to expand...


Try IsNumber(CritRng2) instead of CritRng2=IsNumber().
 
S

SteveDB1

Thanks Glenn,
This appears to work.
I'll let you know if I have any trouble with it.
Again-- thank you.
 
S

SteveDB1

Glenn, just wanted to stop back in and say that my user says it works
excellently.
So-- thank you.
Best.
 

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

COUNT rows on external sheet if between date range 3
countifs Function not giving desired result with date criteria 2
SumProd from 2 columns and date range 6
Spin Box Date and Sumproduct 3
Count if >0 and between dates 14
extract date, networkdays and sumproduct 5
SUMPRODUCT Function Compare Date 3
Summing data between two date criteria 5

Top