If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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) ) |
#2
|
|||
|
|||
SUMIF formula with non contiguous cells
In article ,
Billy B wrote: 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)) Try replacing the SUM/SUMIF part of the formula with the following... SUM(G8:P8,U8,V8)/(SUMIF(G8:P8,"0",G7:P7)+SUMIF(U8:V8,"0",U7:V7)) -- Domenic http://www.xl-central.com |
#3
|
|||
|
|||
SUMIF formula with non contiguous cells
Also, in the VLOOKUP(), you may need a 0 as the last argument
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Billy B" wrote in message ... 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) ) |
Thread Tools | |
Display Modes | |
|
|