**Question description:**

*This user has given permission to use the problem statement for this blog.*

need help....
SUM(COUNTIFS('Parts NC Entry'!$E$2:$E$1934,M9,'Parts NC Entry'!$K$2:$K$1934,"X")+COUNTIF('Parts NC Entry'!$E$2:$E$1934,N9,'Parts NC Entry'!$K$2:$K$1934,"X"))-COUNTIFS('Parts NC Entry'!$E$2:$E$1934,M9,'Parts NC Entry'!$G$2:$G$1934,"TRIAL/SETUP",'Parts NC Entry'!$E$2:$E$1934,M9,'Parts NC Entry'!$K$2:$K$1934,"X")-COUNTIFS('Parts NC Entry'!$E$2:$E$1934,N9,'Parts NC Entry'!$G$2:$G$1934,"TRIAL/SETUP",'Parts NC Entry'!$E$2:$E$1934,N9,'Parts NC Entry'!$K$2:$K$1934,"X")

Solved by V. U. in 15 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
16/12/2017 - 03:27

hello sir

Excelchat Expert
16/12/2017 - 03:27

welcome

Excelchat Expert
16/12/2017 - 03:27

thank you for selecting got it pro

User
16/12/2017 - 03:27

hello

Excelchat Expert
16/12/2017 - 03:28

please tell me how can i help you?

User
16/12/2017 - 03:29

can you understand the count if function how it works?

Excelchat Expert
16/12/2017 - 03:29

yes sir sure

Excelchat Expert
16/12/2017 - 03:30

COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria.

Excelchat Expert
16/12/2017 - 03:31

The syntax for the COUNTIFS function in Microsoft Excel is:
COUNTIFS( criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n] )

Excelchat Expert
16/12/2017 - 03:32

Parameters or Arguments are as follow

Excelchat Expert
16/12/2017 - 03:32

criteria_range1
The range of cells that you want to apply criteria1 against.

Excelchat Expert
16/12/2017 - 03:32

and

Excelchat Expert
16/12/2017 - 03:32

criteria1
The criteria used to determine which cells to count. criteria1 is applied against criteria_range1.

User
16/12/2017 - 03:32

yes

Excelchat Expert
16/12/2017 - 03:33

like wise criteria 2 and criteria range 2 and up to ....n

User
16/12/2017 - 03:34

any example

Excelchat Expert
16/12/2017 - 03:34

yes sure sir

Excelchat Expert
16/12/2017 - 03:37

here in cell a2 i applied this formula

Excelchat Expert
16/12/2017 - 03:37

we count the cell which has value is 200

Excelchat Expert
16/12/2017 - 03:38

the total two numbers of the cell

Excelchat Expert
16/12/2017 - 03:38

if i replace the criteria range with C2:C6 and mentioned the criteria as apple

Excelchat Expert
16/12/2017 - 03:39

then it give us count 2

Excelchat Expert
16/12/2017 - 03:39

are you understand?

User
16/12/2017 - 03:39

I am checking

User
16/12/2017 - 03:41

yes thank you

Excelchat Expert
16/12/2017 - 03:41

do you need any other help?

User
16/12/2017 - 03:41

no thanks

Excelchat Expert
16/12/2017 - 03:42

can i close this session

User
16/12/2017 - 03:42

yes sure

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*