Hi, am trying to lookup and match values [am using Excel 200]
a simplified example of my data -

A B C
1 code name
2 MG1 Name1
3 MG2 Name2
4 MG1 Name3

I am using SUM(COUNTIF(C2C4, etc to add the number of certain names in
column C, the difficulty I have is trying to subtract the number of those
that meet certain criteria, the aim is -

1 search column C for a specified name [eg. name1]
2 lookup code in column B for name1 [MG1]
3 then search column B for an exact match for that code [MG1]
4 read name for that exact matched code in column C [name 3]
5 and count if name 3 is a "sepcified name/text"
then subtract from the original total

Essentially I am trying to account for repetitions where name1 and name3 are
different though should be counted as the same when their repective codes are
identical. I imagine I may need to use a number of functions in my formula
here. Any help with this would be great, many thanks, Roge