| 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 |
| 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 | |||
Threaded Mode
