My Excel formula seems to be only adding the first column in a range. How can I get it to add all the columns in the range? Here is the formula I have tried to use =SUMIF(A3:A62,">99.99","C3:G62"). I want this formula to add all the numbers in C3-C62….G3-G62, if the number in A3:62 is 100 or greater.)
Each column represents a class period and each row represents a student's grade. I would like to know how many students from each class got a 100% on their test.
Follow-up question: What formula would I use to do this for multiple columns/rows and still get only one total?
Any help would be greatly appreciated!
Each column represents a class period and each row represents a student's grade. I would like to know how many students from each class got a 100% on their test.
Follow-up question: What formula would I use to do this for multiple columns/rows and still get only one total?
Any help would be greatly appreciated!