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,648

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

Users Browsing this Thread

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