Table A
Date Model
14/01/2010 2CMHS
14/01/2010 2CMHS
14/01/2010 2CMHS
14/01/2010 2CMHS
05/06/2010 25CMHS
15/01/2011 40XWTL
02/02/2011 FT50CETL
12/03/2011 F150XWTL
20/03/2011 F150XWTL
28/04/2011 F250CETL
Table B
SUMMARY
Model Receipt 2011
2CMHS
25CMHS
40XWTL
FT50CETL
F150XWTL
F250CETL
In table A, I have models received in 2010 & 2011.
I want a formula in table B to count or sum each model received between 01/01/2011 to 31/12/2011.
Can anyone help me out.
Sonny
Date Model
14/01/2010 2CMHS
14/01/2010 2CMHS
14/01/2010 2CMHS
14/01/2010 2CMHS
05/06/2010 25CMHS
15/01/2011 40XWTL
02/02/2011 FT50CETL
12/03/2011 F150XWTL
20/03/2011 F150XWTL
28/04/2011 F250CETL
Table B
SUMMARY
Model Receipt 2011
2CMHS
25CMHS
40XWTL
FT50CETL
F150XWTL
F250CETL
In table A, I have models received in 2010 & 2011.
I want a formula in table B to count or sum each model received between 01/01/2011 to 31/12/2011.
Can anyone help me out.
Sonny