Hi all, I am trying to put together a report for school and need some help. In the attached spreadsheet, I have a summary tab and three tabs for Americas and Europe and JAPAC.
Can someone please help me with this?
- For the summary tab, I need to pull in information from the three tabs (JAPAC, EMEA and Americas).
- For Columns C, D, L, M,N,O these need to be populated (with relevant COUNTS) if the tabs have corresponding information.
- Columns E,F,G,H,I,J need to be populated (with relevant COUNTS) if the tabs have corresponding information and are for 2018
- Columns P,Q,R,S,T,U need to be populated (with relevant COUNTS) if the tabs have corresponding information and are for 2019
Can someone please help me with this?