How do I write a formula that will total "D" for a particular month for a particular year. The spreadsheet has thousands of entries for different years and months. The format for the cells in "C" are custom - "m/d/yyyy h:mm". What would the formula be to total "D" for September 2011? Your help is appreciated.
<tbody>
</tbody>
1 | C | D |
2 | 6/30/2011 12:00:00 AM | 20.00 |
3 | 9/4/2011 5:19:00 PM | 6.00 |
4 | 9/27/2011 5:19:00 PM | 8.00 |
5 | 10/1/2011 6:46:00 PM | 10.00 |
<tbody>
</tbody>
Last edited: