SUMIF formula with non contiguous cells

[Billy B]

I have been trying, without any success, to write a SUMIF function using non
contiguous cells and need some help. Here is the formula I am working
with:=IF(COUNT(G88,U8,V8)<12,"",VLOOKUP(SUM(G88+U8+V8)/SUMIF(G88+U8+V8,">0",$G7:$P$7+U7+V7),GradeTbl,2))

 

[Domenic]

I have been trying, without any success, to write a SUMIF function using non
contiguous cells and need some help. Here is the formula I am working
with:=IF(COUNT(G88,U8,V8)<12,"",VLOOKUP(SUM(G88+U8+V8)/SUMIF(G88+U8+V8,"

Try replacing the SUM/SUMIF part of the formula with the following...

SUM(G88,U8,V8)/(SUMIF(G88,">0",G77)+SUMIF(U8:V8,">0",U7:V7))

 

[Ashish Mathur]

Also, in the VLOOKUP(), you may need a 0 as the last argument

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com