software

I need to sum a range in a column based on the date in another column:
A B
1 DateHours
2 05--Dec-267.2
3 05--Dec-296.8
4 06--Jan-012.1
5 06--Jan-123.3

essentially, i want to say quot;if the date in A is in Dec 05, add the
hours in B that correspond to Dec 05quot;. so, in another cell, in another
sheet, i would get:

A B
1 Dec 0514.0
2 Jan 06 5.4

B1 of the second sheet obviously where my formula would be.
Thanks.
-Carl Eubanks--
Outraged
------------------------------------------------------------------------
Outraged's Profile: www.excelforum.com/member.php...oamp;userid=31491
View this thread: www.excelforum.com/showthread...hreadid=511701
=SUMPRODUCT(--($A$1:$A$500=DATE),$B$1:$B$500)

I think it would be somthing along these lines, sum column A that
equals to the date (you will need to reference a cell with that date
(eg put dec05 in c1) and then it will add all in column B that meet
this--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: www.excelforum.com/member.php...oamp;userid=19492
View this thread: www.excelforum.com/showthread...hreadid=511701
maybe i am using the DATE in the wrong manner, but this doesnt seem to
be working. even if i use and exact date [to include the day, just to
see if i get any results].

I was hoping i could do this without adding another cell [i.e. a
reference cell] that has only the month and year. Would some sort of
IF statement work when referencing a column header? i.e. IF quot;Datequot; =
Jan 06, then add the cells in column quot;Hoursquot; where quot;Datequot; = Jan 06.

[the format of Date is yy--mmm-dd and the actual data is 1/1/2006]

I hope I am explaining myself how I want to.

-Carl Eubanks--
Outraged
------------------------------------------------------------------------
Outraged's Profile: www.excelforum.com/member.php...oamp;userid=31491
View this thread: www.excelforum.com/showthread...hreadid=511701