troubleshooting Question

MS Excel Formula with Multiple Filter

Avatar of Matt Pinkston
Matt Pinkston asked on
Microsoft ExcelMicrosoft Office
3 Comments1 Solution111 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros