| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count blank dates
I need to count in 2 columns this condition.
Column Z =< 5/31/06 Column AA = blank date fields I've tried this but it does not work =SUMPRODUCT(--(TCS!$Z$2:$Z$1000<="5/31/06"),--(TCS!AA2:AA1000="")) Much thanks Sharon -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200606/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count blank cells that contain formula? | Excel Discussion (Misc queries) | |||
| How to count interstitial blank cells? | Excel Discussion (Misc queries) | |||
| COUNT IF BETWEEN DATES | Excel Worksheet Functions | |||
| Count Problem between dates | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
