**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")+COUNTIFS('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 O. E. in 10 mins

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

Excelchat Expert
17/12/2017 - 05:56

welcome sir

Excelchat Expert
17/12/2017 - 05:56

thank you for selecting got it pro

Excelchat Expert
17/12/2017 - 05:57

please tell me how can i help you?

User
17/12/2017 - 05:57

need to understand countifs function

Excelchat Expert
17/12/2017 - 05:58

yes sir

Excelchat Expert
17/12/2017 - 06:00

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

Excelchat Expert
17/12/2017 - 06:00

the syntax of that function is COUNTIFS( criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n] )

Excelchat Expert
17/12/2017 - 06:02

criteria range 1 and criteria 1

Excelchat Expert
17/12/2017 - 06:02

then criteria range 2,3....n

Excelchat Expert
17/12/2017 - 06:02

same criteria 2,3,4,...n

Excelchat Expert
17/12/2017 - 06:04

so we can get our result as per our criteria and from criteria range

Excelchat Expert
17/12/2017 - 06:04

in your sheet the criteria is 'Parts NC Entry'!$E$2:$E$1934,

Excelchat Expert
17/12/2017 - 06:04

criteria range is 'Parts NC Entry'!$E$2:$E$1934,

Excelchat Expert
17/12/2017 - 06:04

and criteria is M

Excelchat Expert
17/12/2017 - 06:05

criteria range 2 is 'Parts NC Entry'!$K$2:$K$1934

Excelchat Expert
17/12/2017 - 06:05

criteria 2 is "x"

Excelchat Expert
17/12/2017 - 06:05

so you can get data as per your criteria and from the range

Excelchat Expert
17/12/2017 - 06:05

are you understand?

User
17/12/2017 - 06:05

yes

Excelchat Expert
17/12/2017 - 06:06

do you have any other doubt with this formula?

User
17/12/2017 - 06:06

no thank you

Excelchat Expert
17/12/2017 - 06:06

can i close this session?

User
17/12/2017 - 06:06

sure

Excelchat Expert
17/12/2017 - 06:07

thank you sir for selecting got it pro

Excelchat Expert
17/12/2017 - 06:07

bye and help us by rating 5 star

User
17/12/2017 - 06:07

ok

**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.*