2 B C D E
3 PolicyStartDate Class ClassTotal VAT
4 01/11/2008 Motor 10,039.24 1,232.89
5 01/11/2008 Motor -200.00 -24.56
6 01/11/2008 Motor 1,150.60 141.30
7 01/11/2008 Non-Motor 12,414.70 1,524.61
8 01/12/2008 Non-Motor 12,414.70 1,524.61
9 01/12/2008 SASRIA 52.75 6.48
10 01/12/2008 SASRIA 52.75 6.48
11
12
13 November December
14 Month Beg 01/11/2008 01/12/2008
15 Month End 30/11/2008 31/12/2008
16 Motor #VALUE!
17 Non-Motor

I am trying to Sum columns D:E for all data that falls in the month of
November 2008, then Decmber 2008, Jan 2009 etc that corresponds to the
definition Motor as per column C but my formula
=SUMIFS(D4:E10,B4:B10,"=C14",B4:B10,"<=C15",C4:C1 0,"=B16") that I have in
C16 is giving me a #VALUE error. Is my logic or my Syntax wrong?