Countifs with mutiple criteria in single column for Google 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

 

[ExceLoki]

i'm curious as to what your desired output would look like

 

[Sufiyan97]

Try

It will be easier to use cell reference, instead of hard coded numbers
You can use any of 1.

Book8.xlsx
	A	B	C	D	E	F	G	H	I
1	Type of update	Copy Status	Completed by				Type of update	Copy Status	Completed by Not Equals
2	Asset & Copy	Completed	Anuj				Asset & Copy	Completed	YY
3	Copy	Completed	Anuj				Copy	No longer required	Juliana
4	Asset & Copy	Completed	Anuj				Add Clean Label & Category	No Change Were Identified
5	Copy	Completed	Rupali				Remove Clean Label & Category
6	Remove Clean Label	Completed	Rupali
7	Add Clean Label	No Longer Required	YY		Formula 1	17
8	Copy	No Longer Required	Rupali		Formula 2	17
9	Copy	No Longer Required	Rupali
10	Asset & Copy	Pending Brand/Merch	Juliana
11	Asset & Copy	No Longer Required	Anuj
12	Asset & Copy	Completed	Anuj
13	Add Clean Label & Category	Completed	Anuj
14	Remove Clean Label & Category	Completed	Rupali
15	Copy	Completed	YY
16	Copy	Completed	Rupali
17	Copy	Completed	Juliana
18	Copy	Completed	Anuj
19	Asset	Completed	Rupali
20	Asset & Copy	Completed	Rupali
21	Asset & Copy	Completed	Rupali
22	Asset & Copy	No Change Were Identified	YY
23	Asset & Copy	No Change Were Identified	Rupali
24	Asset	No Change Were Identified	Juliana
25	Asset & Copy	No Change Were Identified	Anuj
26	Asset & Copy	No Change Were Identified	YY
27	Asset & Copy	No Change Were Identified	Rupali
28
Sheet1

Cell Formulas
Range	Formula
F7	F7	=SUMPRODUCT(ISNUMBER(MATCH($A$2:$A$27,{"Asset & Copy","Copy","Add Clean Label & Category","Remove Clean Label & Category"},0))*ISNUMBER(MATCH($B$2:$B$27,{"Completed","No Longer Required","No Change Were Identified"},0))*NOT(ISNUMBER(MATCH($C$2:$C$27,{"YY","Juliana"},0))))
F8	F8	=SUMPRODUCT(ISNUMBER(MATCH($A$2:$A$27,$G$2:$G$5,0))*ISNUMBER(MATCH($B$2:$B$27,$H$2:$H$4,0))*NOT(ISNUMBER(MATCH($C$2:$C$27,$I$2:$I$3,0))))