Announcement

Collapse
No announcement yet.

Sum If With Multiple Criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sum If With Multiple Criteria

    Hai All
    This Is My First Mail On This Fourm,
    Iam Looking For Sum If With Multiple Criteria
    Sumif(a2:a22=d2 And B2:b22=e2 Sum Should Be Sorted Result Of Array C2 C22)
    How Do I Put The Formula
    Raj
    Attached Files

  • #2
    Re: Sum If With Multiple Criteria

    Please search and read the autolinks. This question is answered daily.

    Comment


    • #3
      Re: Sum If With Multiple Criteria

      Originally posted by Dave Hawley
      Please search and read the autolinks. This question is answered daily.
      could you provide me the link for ans question

      Comment


      • #4
        Re: Sum If With Multiple Criteria

        Hi Raj,

        Welcome to board!

        Try

        =SUMPRODUCT(--(A2:A22=D2),--(B2:B22=E2),C2:C22)

        HTH
        Kris

        ExcelFox

        Comment


        • #5
          Re: Sum If With Multiple Criteria

          Originally posted by Krishnakumar
          Hi Raj,

          Welcome to board!

          Try

          =SUMPRODUCT(--(A2:A22=D2),--(B2:B22=E2),C2:C22)

          HTH
          thnaks kris this is exactly what iam looking for
          thabks a lot
          raj

          Comment

          Working...
          X