conditional counts across columns

[Steven Stovall]

I want to count the number of times the date in cell (Row=N,Column=M)
is later than the date in cell (Row=N,Column=J), where N ranges down
some number of rows. Is there a way of doing this with pure Excel
expressions? I think it could be done with some magic combination of
INDIRECT, OFFSET, ROW, and so on, but for example the formula
=IF(("$D$"&ROW())>"$C$"&ROW(),1,0) seems to compare the strings and
not the contents of the cells.

Steven Stovall
(e-mail address removed)

 

[Frank Kabel]

Hi
could you give some real cell references. I think COUNTIF isn what
you're looking for

 

[Bob Phillips]

Steve,

This sounds like a simple

=SUMPRODUCT(--(M1:M100>J1:J100))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Steven Stovall]

Steve,

This sounds like a simple

=SUMPRODUCT(--(M1:M100>J1:J100))

--

That did the trick. I'm brand new to this stuff and I appreciate the help.

Steven Stovall