Thread: Data counting

Hi.....

right i have been trying to work this out now for hours .....

basically i have 4 coloums name, age, height, hair color say and i want to count up how many time kerry appears on my sheet, but i also want it to count how many times kerry's age 9; 6ft ; blonde appears.

is this possible?

Use SUMPRODUCT, and populate the arrays with all the different variables you need to make your match