help needed: sumif isn't adding all the columns in a range

[jjf]

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!

 

[orbea_adam]

jjf, Welcome! Here's how I see it:

Book1
	A	B	C	D	E	F
2			Period1	Period2	Period3	>=100
3	100		1	2	3	18
4	89		1	2	3
5	90		1	2	3
6	100		1	2	3
7	101		1	2	3
Sheet1

&gt is supposed to be ">"

 

[Aladin Akyurek]

SumIf requires the same number of condition ranges and ranges to sum. That said, try...

=SUM(IF(A3:A62>99.99,C3:G62))

which must be confirmed with control+shift+enter, not just with enter.

 

[jjf]

The control+shift+enter worked!
Thanks so much!