Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Sum If With Multiple Criteria

1. I agreed to these rules
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

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Sum If With Multiple Criteria

3. I agreed to these rules
Join Date
17th June 2008
Posts
11

## Re: Sum If With Multiple Criteria

Originally Posted by Dave Hawley
could you provide me the link for ans question

Excel Video Tutorials / Excel Dashboards Reports

4. Super Moderator
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. I agreed to these rules
Join Date
17th June 2008
Posts
11

## 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

Excel Video Tutorials / Excel Dashboards Reports

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

#### 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