MS Excel Formula with Multiple Filter

Matt Pinkston
Matt Pinkston used Ask the Experts™
on
I had posted a question asking the following but now have an additional requirement

Original Question
I have an excel spreadsheet that I need to add some formula columns to...
In tab Data column H i have values for position type
In tab Summary I have lines for each position type
- I need a formula that gives me the total count of records in tab Data where column h = column Bx from tab Summary
Solution:=COUNTIFS(Employees!I:I,B3)
- I also need a formula that gives me the total of tab Data column P where column h = column Bx from tab Summary
Solution:=SUMPRODUCT((Employees!I2:I74=B3)*Employees!Q2:Q74)

In both cases now I need to be able to add an additional criteria that column D = India

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
You may add the additional criteria like this in both the formulas...

=COUNTIFS(Employees!I:I,B3,Employees!D:D,"India")

Open in new window

and

=SUMPRODUCT((Employees!I2:I74=B3)*(Employees!D2:D74="India")*Employees!Q2:Q74)

Open in new window

Matt PinkstonEnterprise Architect

Author

Commented:
Excellent Thanks
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You’re welcome Matt!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial