Not clear (to me, anyway) what you are trying to do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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"}))