Hi all!

Looking for some help with an excel formula that is driving me crazy!!!

Basically, I am trying to use a formula to detect the number of different 'Names' that appear in my table, but by having set criteria in 3 other columns.

For instance, I want the results to only show those that also meet the criteria of Status = "Active", Family = "Williams" and Product = "Slab".

I know that the result should be 2, (as both Marcus and Sirius match this), but I can't work it out!!!

Anybody got any ideas???? So confused by this!!!

Thanks in advance!!!

Excel Screenshot.JPG