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.