Results 1 to 2 of 2

Thread: Excel Summing or counting

  1. #1

    Unhappy Excel Summing or counting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Assuming Table B is in column J, try

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •