| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
I have a spreadsheet containing thousands of records (each row is a different
record) and 20 different data columns. I want to count the number of records when the a specific number is in one column and a date (any date) appears in the second column. The column containing the dates may also contain blank cells, since this column is not filled in until some action triggers the need to put in a date. I've tried the following formula and get "0". Can someone help? =SUMPRODUCT((E4:E869="1247.24")*(AC4:AC869="01/01/2006")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting | Excel Discussion (Misc queries) | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Counting | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Threaded Mode
