Results 1 to 4 of 4

Thread: Sumif and

  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    =SUMIF(G:G,S12,P:P) and.....

    I need to sum column P if column G = S12 and column D = T11. How please?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    =SUMPRODUCT((D220="T11")*(G2:G20="S12"),(P2:P20))

    or, if your were referring to cells T11 and S12

    =SUMPRODUCT((D220=T11)*(G2:G20=S12),(P2:P20))

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I forgot to mention that your arrays need to be the same size (number of rows) and the entire column cannot be referenced - such as G:G.

  4. #4

Posting Permissions

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