Forum Discussion
COUNTIFS Range Not Working
you are missing some quotes. try this:
=COUNTIFS(D40:CU40,"<50",D40:CU40,">-1")also to freeze both horizontal and vertical select the top left cell that you want in the moving section (i.e. all rows above it should freeze and all columns to the left of it should freeze) then select freeze panes
on another note you might consider transposing your data. Think about what IF you want to use the built in table filters because they only filter rows so does it make sense to look at a column and set a filter to refine your view. Presently I believe your columns are students so I don't think that would make much sense to filter the rows across all students based on 1 student's grade, but if you flip the table and the columns are classes then you might want to filter the rows (i.e. students) to see which students are presently failing or haven't submitted a report yet or are doing really well... just my 2 cents.
Hi,
To include both 0 and the number 49 in your formula calculation, you would need to write this formula like this:
=COUNTIFS(D40:CU40, ">=0", D40:CU40, "<=49")
Make sure you have correctly set the range of cells you want to calculate.
Hope this helps.
IlirU