Excel: Count If with multiple criteria and unique values

Hi, I dont know if this is possible or not but thought I'd ask anyway. I have a sheet of data and want to run a count on the values in Column A with the following criteria: - If the value in column B is repeated then the value in column A can only be counted once... - Column C must equal 'M'. Example: A.....B.....C 1.....42....M 1.....42....M 2.....41....A 2.....41....M 1.....56....M In this example 1 would be counted 2 times, and 2 would be counted once. I have about 15 sheets of data like this and would like a master sheet to look into each sheet and give me a count of each so id prefer to not use the advanced filter => unique variables option if possible. Any help would be greatly appreciated. Dixon.

This question generated 89 answers. To proceed to the answers, click here.

This thread is current as of April 02, 2008.

For more resources for Microsoft Excel