| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Date count
I have a spreadsheet with dates in the cells.
I want to create a formula that looks at column A and column B, if they are blank... then look at column C and if it is blank count it as 1. I tried something like this.. but it didn't give me the answer I was looking for! =SUMPRODUCT(--(A7&B7=" "),(COUNTA(C7,1))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Threaded Mode
