Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Bruce wrote...
Harlin, .... First, if you can't bother to spell names correctly, don't bother including salutations. I want the row-wise sum of CW2:CH300 if the corresponding row-wise sum of CT2:CW2 = 0. You showed CW2:DH300 before, not CH2:CW300. I'll assume the original was correct. I screwed up my second range reference. Try =SUMPRODUCT(--(MMULT(CT2:CW300,{1;1;1;1})=0), MMULT(CW2:DH300,{1;1;1;1;1;1;1;1;1;1;1;1})) If you actually do want to sum CH:CW, then use =SUMPRODUCT(--(MMULT(CT2:CW300,{1;1;1;1})=0), MMULT(CH2:CW300,{1;1;1;1;1;1;1;1;1;1;1;1;1;1;1;1}) ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
sumif columns and rows | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions | |||
Formula help SUM(IF((... | Excel Worksheet Functions |