Formula to sum up in different columns

Hi all,

I need to come up with a formula that sums up the total positive numbers for each colour in one column and the total negative numbers for each colour in a separate column. So the Totals in columns C and D should show sums of numbers (positive or negative) between two Totals in column B. I've been struggling with this little issue all morning, so any help would be much appreciated.

Thanks!

Thank you!

Since there are hundreds of "colours", I need D7 and E7, D14 and E14, etc. to show the totals for the color above. So the formula should include that if A7 is "Total", then I get the total of the positive/negative numbers between B3 and B6, else I get the positive/negative number as you suggested. However, I'm not sure how to indicate in the formula on what cells should be summed up in "Total".

Originally Posted by Deria

...I need D7 and E7, D14 and E14, etc. to show the totals for the color above.

So, based on your sample file / values, something like:

Formula:

Please Login or Register  to view this content.

That's exactly what I needed! Thank you!