conditional counts across columns
 

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

conditional counts across columns
 

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

conditional counts across columns
 

Steve,

This sounds like a simple

=SUMPRODUCT(--(M1:M100J1:J100))

--

HTH

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


"Steven Stovall" wrote in message
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

conditional counts across columns
 

"Bob Phillips" wrote in message ...
Steve,

This sounds like a simple

=SUMPRODUCT(--(M1:M100J1:J100))

--

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

Steven Stovall