Hi friends
Please i was wondering if anyone could help out with a formula that could count based on multiple criteria
i need to count a range of column with different value the meet and do not meet that if ( Half equal 10 and Full equal 16) so i need to count are many that meet and do not meet for each criteria
here is my table appreciate if anyone can help me with a formula that can count based on multiple criteria
Please i was wondering if anyone could help out with a formula that could count based on multiple criteria
i need to count a range of column with different value the meet and do not meet that if ( Half equal 10 and Full equal 16) so i need to count are many that meet and do not meet for each criteria
here is my table appreciate if anyone can help me with a formula that can count based on multiple criteria
Book2 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | |||||||||||||||||
2 | Full | Half | |||||||||||||||
3 | 16 | 10 | |||||||||||||||
4 | Meet | Do Not meet | |||||||||||||||
5 | A-221 | Half | 9 | 8 | 12 | 19 | 25 | 10 | 10 | 10 | 15 | ||||||
6 | A-221 | Full | 10 | 25 | 15 | 19 | 16 | 14 | 16 | 45 | 12 | ||||||
7 | A-222 | Half | 9 | 8 | 12 | 19 | 25 | 10 | 10 | 10 | 15 | ||||||
8 | A-223 | Full | 10 | 25 | 15 | 19 | 16 | 14 | 16 | 45 | 12 | ||||||
9 | A-224 | Half | 9 | 8 | 12 | 19 | 25 | 10 | 10 | 10 | 15 | ||||||
10 | A-225 | Half | 9 | 8 | 12 | 19 | 25 | 10 | 10 | 10 | 15 | ||||||
11 | |||||||||||||||||
Sheet1 |