Excel - SUM Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.