I had posted a question asking the following but now have an additional requirement
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
- I also need a formula that gives me the total of tab Data column P where column h = column Bx from tab Summary
In both cases now I need to be able to add an additional criteria that column D = India