I have a table
Student Exp Edu
A 8 12
B 8 11
C 9 CD
D 9 DH
E 10 9
F 10 2
G 5 3
H 4 TC
I want count how many student same as:
Cap I (Edu <5)
Cap II (Edu 5<x<=9)
Cap III (Edu 9<x<=12)
TC, CD: (Edu x = TC + CD)
DH: (Edu x= DH)
How i do that function?
I have a table
Student Exp Edu
A 8 12
B 8 11
C 9 CD
D 9 DH
E 10 9
F 10 2
G 5 3
H 4 TC
I want count how many student same as:
Cap I (Edu <5)
Cap II (Edu 5<x<=9)
Cap III (Edu 9<x<=12)
TC, CD: (Edu x = TC + CD)
DH: (Edu x= DH)
How i do that function?
Hi,
Cap I (Edu <5) =COUNTIF(C2:C9,"<5")
Cap II (Edu 5<x<=9) =COUNTIF(C2:C9,"<=9")-COUNTIF(C2:C9,"<5")
Cap III (Edu 9<x<=12) =COUNTIF(C2:C9,"<=12")-COUNTIF(C2:C9,"<9")
TC, CD: (Edu x = TC + CD) =COUNTIF(C2:C9,"TC")+COUNTIF(C2:C9,"CD")
DH: (Edu x= DH) =COUNTIF(C2:C9,"DH")
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Both these formulas will count 9, change the second one toOriginally Posted by sweep
=COUNTIF(C2:C9,"<=12")-COUNTIF(C2:C9,"<=9")
to count "TC" and "CD" try
=SUM(COUNTIF(C2:C9,{"TC","CD"}))
Thx for guide.
It's work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks