Match values in 2 columns and return the sum

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

Thanks, the formula in column I works great. What is the formula to enter into column J to output the FY12 data?

Thanks!!

Can the output be achieved without adding details into column H on the co-leading & Scpoing tab?

The data will grow over time, thus I need a formula which looks purely at the columns available today.

Thanks,
shaz_79