Matt Pinkston

asked on

# Formula Help on Tab to Another

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

Thanks

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

Thanks

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER