Hi,
I would appreciate some assistance with the following.
I have a spreadhseet with multiple tabs, I need to checj a tab and match data in 2 columns and then the result should appear as a count in another tab. For example, in cell I3 in tab 'Productivity Table', I want there to be a formula that checks tab 'Co-Leading & Scoping' and identifies if Column C = 'Adam B' and if column A does not equal 'FY12'. If so, the total number of occurences should be output to the tab 'Productivity Table' in cell I3.
Similarly in cell J3 on the tab 'Productivity Table', I again want to check the tab 'Co-Leading & Scoping', but this time check for 'Adam S' in column C and 'FY12' in colum A.
Please see spreadsheet attached to see the data I am referring to above.
If you are able to demonstrate the answer with a working example, that would be great.
Thanks!
shaz_79
Bookmarks