| Home > Forum Home > Analyzing Corporate Financial Data > Lookup and Sum | Share |
Lookup and Sum
Excel Help for Lookup And Sum in Analyzing Corporate Financial Data
| Forum Topic | Post Reply Login |
Lookup And Sum | Rate this: (3/5 from 1 vote) |
 | Cell A1 is a year 2009 Cells A4:A100 are Dates (from 2002 - Present) Cells D4:D100 contain Data (Numbers) Cell D1 needs to Count the number of cells D4:D100 that are not blank for each the corresponding A4:A100 that = Cell A1 (2009) 2009 1 1/1/8 21 2/1/8 33 3/1/9 44 Thanks for any help. M. | |
| Posted by mengelha on | ||
| There are currently no replies to the "Lookup and Sum" topic of the Excel Help Forum for Analyzing Corporate Financial Data. Post Reply |
| Find relevant Excel templates and add-ins for Lookup and Sum in the Excel Business Solutions Directory |