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 TopicPost Reply Login

Lookup And Sum

Rate this:
(3/5 from 1 vote)
ConfusedCell 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 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