Countifs with mutiple criteria in single column in G sheets

[Sunil7598]

Hi Guys,

I trying get as per Countifs with mutiple criteria in single column. Row 1 is a header

Criteria:
1)Type of update should be = Asset & Copy, Copy, Add Clean Label & Category, Remove Clean Label & Category
2) Copy Status = Completed, No longer required, No changes were identified
3) Completed by Should not be equal to <> YY, Juliana

Every column has some blanks cells also. Tried a lot of things but failed.

Kindly help me

Type of update	Copy Status	Completed by
Asset & Copy	Completed	Anuj
Copy	Completed	Anuj
Asset & Copy	Completed	Anuj
Copy	Completed	Rupali
Remove Clean Label	Completed	Rupali
Add Clean Label	No Longer Required	YY
Copy	No Longer Required	Rupali
Copy	No Longer Required	Rupali
Asset & Copy	Pending Brand/Merch	Juliana
Asset & Copy	No Longer Required	Anuj
Asset & Copy	Completed	Anuj
Add Clean Label & Category	Completed	Anuj
Remove Clean Label & Category	Completed	Rupali
Copy	Completed	YY
Copy	Completed	Rupali
Copy	Completed	Juliana
Copy	Completed	Anuj
Asset	Completed	Rupali
Asset & Copy	Completed	Rupali
Asset & Copy	Completed	Rupali
Asset & Copy	No Change Were Identified	YY
Asset & Copy	No Change Were Identified	Rupali
Asset	No Change Were Identified	Juliana
Asset & Copy	No Change Were Identified	Anuj
Asset & Copy	No Change Were Identified	YY
Asset & Copy	No Change Were Identified	Rupali

 

[Fluff]

Duplicate to: Countifs with mutiple criteria in single column for Google Sheets

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.