Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Formula to counts multiple criteria in two columns? | Excel Worksheet Functions | |||
How does a macro total columns when sheets have diff row counts? | Excel Discussion (Misc queries) | |||
Need formula that Counts items matching criteria using two columns | Excel Worksheet Functions | |||
excel command that counts conditions met in 2 columns? | Excel Discussion (Misc queries) | |||
Averages and Counts from different columns | Excel Worksheet Functions |