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

--
Regards
Frank Kabel
Frankfurt, Germany

"Steven Stovall" schrieb im Newsbeitrag
m...
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