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.