Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Sum If With Multiple Criteria

  1. #1
    Join Date
    17th June 2008
    Posts
    11

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

    Re: Sum If With Multiple Criteria

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

  3. #3
    Join Date
    17th June 2008
    Posts
    11

    Re: Sum If With Multiple Criteria

    Quote 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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Sum If With Multiple Criteria

    Hi Raj,

    Welcome to board!

    Try

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

    HTH

  5. #5
    Join Date
    17th June 2008
    Posts
    11

    Re: Sum If With Multiple Criteria

    Quote 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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 2
    Last Post: September 23rd, 2008, 06:19
  2. Replies: 5
    Last Post: August 5th, 2008, 03:50
  3. Replies: 14
    Last Post: December 20th, 2006, 10:24
  4. Replies: 5
    Last Post: October 23rd, 2006, 18:54
  5. Replies: 5
    Last Post: September 29th, 2006, 12:58

Bookmarks

Posting Permissions

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