Hi,
First, sorry if I sound confusing.
I have two columns, one constains names which contains duplicates, second column contains status names and they also contain duplicates. The task that I want to fulfill is to count the number of occurence on the name field and if second column meets certain status.
I can only come up with this:
=COUNTIF (D3: D100,"Nash")
this counts the number of occurence "Nash" appears on column D. Now, how can I make change in a way that it checks the right column for status labels?
COUNT D if contains "Nash" AND right column E = "Queu".
please help.
First, sorry if I sound confusing.
I have two columns, one constains names which contains duplicates, second column contains status names and they also contain duplicates. The task that I want to fulfill is to count the number of occurence on the name field and if second column meets certain status.
I can only come up with this:
=COUNTIF (D3: D100,"Nash")
this counts the number of occurence "Nash" appears on column D. Now, how can I make change in a way that it checks the right column for status labels?
COUNT D if contains "Nash" AND right column E = "Queu".
please help.