We help IT Professionals succeed at work.

Formula Help on Tab to Another

Matt Pinkston
Matt Pinkston used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Cost Accountant
Top Expert 2012
Commented:
Formula 1 would likely be a COUNTIFS and Formula 2 would be SUMIFS:

Such that:

=COUNTIFS(Data!H:H,B1)

Open in new window

=SUMIFS(Data!P:P,Data!H:H,B1)

Open in new window


These can be expanded if more criteria are required.
Matt PinkstonEnterprise Architect

Author

Commented:
Thanks so much