We help IT Professionals succeed at work.

# MS Excel Formula with Multiple Filter

on
106 Views

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
Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
###### Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

Deciding to stick with EE.

Mohamed Asif

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant