Thread: Sum Numbers up to Number in Top Column Thanks:  2 Post #5288009 (1)Post #5289098 (1) Likes:  2 Post #5288009 (1)Post #5289098 (1)

1. 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:C\$2,"<0")),\$B4,""),""))
What about product 20 and 21. They will not have any value in Cust columns.  Reply With Quote

2. 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)?  Reply With Quote

3. Re: Sum Numbers up to Number in Top Column 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: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!!!   Reply With Quote

4. Re: Sum Numbers up to Number in Top Column

Thanks for feedback  Reply With Quote

User Tag List

Tags for this Thread

column, complicated, customer, data, product  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•