I need to sum a range in a column based on the date in another column:
A B
1 Date Hours
2 05--Dec-26 7.2
3 05--Dec-29 6.8
4 06--Jan-01 2.1
5 06--Jan-12 3.3
essentially, i want to say "if the date in A is in Dec 05, add the hours in B that correspond to Dec 05". so, in another cell, in another sheet, i would get:
A B
1 Dec 05 14.0
2 Jan 06 5.4
-Carl Eubanks
Bookmarks