| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm trying to use COUNTIFS to count how many times someone attendedtutoring, but in a data range such as 4-9 or 2-3
I am using Countif to see how many people that attended one time got A's and that worked as =COUNTIFS(C36:C65,"1",B36:B65,"a")
And when it came to attendance of 10+, that worked as =countifs(C36:C65,"9",B36:B65,"a") My problem is two other data sets that require multiple countif ranges. 2-3 attendance and 4-9. I would think it would be something like 1 and <4 for the 2-3 and 3 and <10 for the 4-9, but I've tried so many things for it to count those. In the C column, there is the amount of times each person attended and the column b is the grade they got. How can you use COUNTIFS for more ranges to count? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count a range of times and link it another worksheet. | Excel Discussion (Misc queries) | |||
| Countifs -Count no of times products have been sold on particular | Excel Worksheet Functions | |||
| Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
| Count times that are more than 5 minutes in a range from a newworksheet | Excel Worksheet Functions | |||
| Count how many times a certain value is in a certain range | Excel Discussion (Misc queries) | |||
Threaded Mode
