sounds like you want

=sumproduct(--(A2:A367<=date selected),B2:B367)

"ronbwa" wrote:

On my worksheet Column A contains dates 1/1/08 thru 12/31/08 (A2:A367)
Column B contains entries for dates in Column A. When I select a certain
date I want to be able to count the cells in Column B that contains a number
up to and including the date selected. Can anyone help?