Counting number of cells with enique text values.

[asyamonique]

Hello, please help me with given formula below.
It doesn't give the correct results.
It should calculate the text values from named master sheet located B:F which names located at A:A
Same as on Main worksheet name located t A19 and the text value on AK5
Thanks a lot.

=SUM(IF(Master!$A:$A=Main!$A$19,IF(Master!$B:$AF=Main!$AK$5,,1)))

 

[sijpie]

It is not very clear what you are trying to do.

I would suggest that you build up your formula. So don't nest two IF() statements immediately. First get the inner IF() formula to work.
Then try the next IF()
Then add the SUM()