i'm just trying to count the number of dates in column D greater than the dates in column C, this works for single cells, but not a range - can anyone help?
EDIT** as OP says, when using a range it returns a 0 value.
Please Login or Register to view this content.
Last edited by fabrecass; 01-23-2013 at 04:22 AM.
May be:
=COUNTIF(D:D,">"&C2)
Quang PT
Comparing row by row? d2 to c2
d3 to c3 etc...?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Maybe this...
=SUMPRODUCT(--(D2:D10>C2:C10))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
yes i am Fotis.
I'll give that a try now Tony.
EDIT** thanks again Tony - perfect.
Last edited by fabrecass; 01-23-2013 at 04:22 AM.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks