Excel formular to Count values in cells of rows that meet crit
Thank you! This formula works perfectly. I appreciate your prompt reply and
expertise.
"John Bundy" wrote:
With date in Column A, data in B, put the date you want to lookup in D and
this formula in E =SUMIF(A1:A5,D1,B1:B5)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"LuvJ1s" wrote:
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
|