Excel Summing or counting

Sonny

New member
Joined
Mar 20, 2011
Messages
3
Reaction score
0
Points
0
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
 
Assuming Table B is in column J, try

=SUMPRODUCT(--($B$2:$B$20=$J2),--(YEAR($A$2:$A$20)=2011))
 
Back
Top