View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LuvJ1s LuvJ1s is offline
external usenet poster
 
Posts: 4
Default Excel formular to Count values in cells of rows that meet criteria

I am attempting to add a formula in a separate spreadsheet that counts the
value in existing cells if the row begins with a certain date. For example,
I would like the spreadsheet to return the 'Amount' received on 12/31/2008
(15.00) and disregard all other dates.

Date Amount
12/31/2008 5.00
12/31/2008 10.00
1/1/2009 2.00
1/1/2009 4.00
1/2/2009 1.00