Hi Guys - Me Again
I have received a new reporting section, and the effort to summarizes takes me a whole week. I am sure Xcel can help get there sooner.
PLease see the attachment
Every Month i get a report, which I copy and paste in the "Strength vs Complement" tab. I have 18 tabs to do, but only need help with the Summary ones.
I want do formulas in the F8/F10/F12 tabs to go and retrieve the data, but don't know how to tell excel to look at 2 cells and then retrieve a sum value...
Example TAB F8
I need cel E9 to go to the Strength vs Complement" tab and look at colom G and I, then count the occurances. How many is namibian and permanent, then count together and give a value.
Same with F10, it should look at Colom E and AE to see how many compliments is in category...
SECONDLY, the report will be re-pasted every month, thus if I have formulas in for every cell in the Tabs 8/10/12, then paste a new report, then all my data change. I am not sure who to go about this, or I should create a tab for every month of the year and paste the reports in the corresponding month?
I would appreciate some insight... i thought the Sumifs would do, but don't seem to retrieve any data (See in F8 cell E9)
Many thanks
Bookmarks