Just a thought

=SUMPRODUCT(SUMIF(INDIRECT({"F7:AS7","AW7:CG7","CK 7:EE7","EJ7:EX7","FB7:FS7","FW7:GW7","HB7"}),"0") )/
SUMPRODUCT(SUMIF(INDIRECT({"F7:AS7","AW7:CG7","CK7 :EE7","EJ7:EX7","FB7:FS7","FW7:GW7","HB7"}),"0",
(INDIRECT({"F5:AS5","AW5:CG5","CK5:EE5","EJ5:EX5", "FB5:FS5","FW5:GW5","HB5"}))))

but how about redesigning the data?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Billy B" wrote in message
...
I am trying to calculate a percent based on the SUMIF function using
non-continuous cells. Row 5 of the worksheet contains the possible points
and
row 7 the points the student has received. Have been working at it a while
and having problems getting it to work. Below is what I have so far. Any
help would be appreciate

=IF(SUM(F7:AS7,AW7:CG7,CK7:EE7,EJ7:EX7,FB7:FS7,FW7 :GW7,HB7)=0,0,SUMIF({"F7:AS7"AW7:CG7","CK7:EE7","E J7:EX7","FB7:FS7","FW7:GW7","HB7"},"=0",{"F7:AS7" ,"AW7:CG7","CK7:EE7","EJ7:EX7","FB7:FS7","FW7:GW7" ,"HB7"}/{"$F$5:$AS$5","$AW$5:$CG$5","$CK$5:EE$5","EJ$5:EX$ 5","FB$5:FS$5","FW$5:GW$5","HB$5"}))