conditional counts across columns

conditional counts across columns

Post by stov75 » Sat, 04 Dec 2004 04:37:03


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
XXXX@XXXXX.COM
 
 
 

conditional counts across columns

Post by Frank Kabe » Sat, 04 Dec 2004 05:04:16

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

"Steven Stovall" < XXXX@XXXXX.COM > schrieb im Newsbeitrag

 
 
 

conditional counts across columns

Post by Bob Philli » Sat, 04 Dec 2004 05:30:03

Steve,

This sounds like a simple

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

--

HTH

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

conditional counts across columns

Post by stov75 » Sun, 05 Dec 2004 02:10:52


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

Steven Stovall