I have an excel with several tabs - Main, Apples, Bananas, Grapes, Carrots....
On the Main tab column A contains all the tab names
What I need to do is in cell B2 of Main tab is:
if A2= Apples, then go to the tab Apples , count all the 'Yes' in column F of Apple tab and return the count value to cell B2 of Main tab.
And then fill the formula to all the cell of column B, so if A3= Bananes then go to the tab Bananas, count all the 'Yes' in Column F of Bananas tab and return the count value to cell B3 of Main tab.
Thank you so much for your help