Thread: SUMIF formula with non contiguous cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy B Billy B is offline
external usenet poster
  
Posts: 54
Default SUMIF formula with non contiguous cells
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(G8:P8,U8,V8)<12,"",VLOOKUP(SUM(G8:P 8+U8+V8)/SUMIF(G8:P8+U8+V8,"0",$G7:$P$7+U7+V7),GradeTbl,2) )
Reply With QuoteReply With Quote