Re: Sum Numbers up to Number in Top Column

Try this. In C4 then dragged across.

Code:

`=IF(AND($B4>0,C$2>0),IF(AND(SUMIF($B$4:$B4,">0")>SUMIF($B$2:B$2,">0"),SUMIF($B$4:$B4,">0")<=SUMIF($B$2:C$2,">0")),$B4,""),IF(AND($B4<0,C$2<0),IF(AND(SUMIF($B$4:$B4,"<0")<SUMIF($B$2:B$2,"<0"),SUMIF($B$4:$B4,"<0")>=SUMIF($B$2:C$2,"<0")),$B4,""),""))`

What about product 20 and 21. They will not have any value in Cust columns.

Re: Sum Numbers up to Number in Top Column

I'm struggling to understand how to interpret and handle negative numbers. Perhaps I should only use numbers in the calculations that have the same sign? So customers A-E and G ignore the -10 in B22, and customer F ignores everything except B22? And in your example from post 8, shouldn't I23 be a valid result (black not red)?

Re: Sum Numbers up to Number in Top Column

Quote:

Originally Posted by

**kvsrinivasamurthy**
Try this. In C4 then dragged across.

Code:

`=IF(AND($B4>0,C$2>0),IF(AND(SUMIF($B$4:$B4,">0")>SUMIF($B$2:B$2,">0"),SUMIF($B$4:$B4,">0")<=SUMIF($B$2:C$2,">0")),$B4,""),IF(AND($B4<0,C$2<0),IF(AND(SUMIF($B$4:$B4,"<0")<sumif($b$2:b$2,"<0"),sumif($b$4:$b4,"<0")>=SUMIF($B$2:C$2,"<0")),$B4,""),""))`

What about product 20 and 21. They will not have any value in Cust columns.

This worked like a charm.

**Thank you SO much, kvsrinivasamurthy & Eric W!!! **</sumif($b$2:b$2,"<0"),sumif($b$4:$b4,"<0")>**:biggrin:**

Re: Sum Numbers up to Number in Top Column