# Need to sum all positive numbers and all negative numbers separately then divide positive numbers by positive result and negative numbers by negative

#### naimack

##### New Member
<table border="0"><tbody><tr><td>

<table style="width: 80px;" border="0" cellpadding="0" cellspacing="0"><colgroup span="1"></colgroup><col span="1" width="80"><tbody><tr height="17"><td class="xl67" height="17" width="80">90,531.54</td></tr><tr height="17"><td class="xl68" height="17">33,185.39</td></tr><tr height="17"><td class="xl68" height="17">26,725.28</td></tr><tr height="17"><td class="xl68" height="17">11,055.71</td></tr><tr height="17"><td class="xl68" height="17">10,200.00</td></tr><tr height="17"><td class="xl68" height="17">6,132.47</td></tr><tr height="17"><td class="xl68" height="17">3,232.69</td></tr><tr height="17"><td class="xl67" height="17">17,047.09</td></tr><tr height="17"><td class="xl68" height="17">12,077.13</td></tr><tr height="17"><td class="xl68" height="17">3,773.95</td></tr><tr height="17"><td class="xl68" height="17">1,196.00</td></tr><tr height="17"><td class="xl67" height="17">-46,173.84</td></tr><tr height="17"><td class="xl68" height="17">2,800.50</td></tr><tr height="17"><td class="xl68" height="17">-1,850.00</td></tr><tr height="17"><td class="xl68" height="17">-3,059.75</td></tr><tr height="17"><td class="xl68" height="17">-4,440.00</td></tr><tr height="17"><td class="xl68" height="17">-4,601.99</td></tr><tr height="17"><td class="xl68" height="17">-5,300.00</td></tr><tr height="17"><td class="xl68" height="17">-5,536.00</td></tr><tr height="17"><td class="xl68" height="17">-8,960.00</td></tr><tr height="17"><td class="xl68" height="17">-15,226.60</td></tr><tr height="17"><td class="xl67" height="17">51,963.12</td></tr><tr height="17"><td class="xl68" height="17">29,694.00</td></tr><tr height="17"><td class="xl68" height="17">13,614.12</td></tr><tr height="17"><td class="xl68" height="17">5,085.00</td></tr><tr height="17"><td class="xl68" height="17">3,570.00</td></tr></tbody></table>

PLease view blue numbers as value with colored background, also the results from division should populate adjacent row (O).
</td></tr></tbody></table>

Last edited:

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Weaver

##### Well-known Member
What causes the colour? Is it cell shading or conditional formatting? If the latter, what's the condition? What version of XL?

#### naimack

##### New Member
The color change is just cell shading

#### naimack

##### New Member
also version of excel is 2003

Replies
1
Views
378
Replies
10
Views
660
Replies
4
Views
6K
Replies
4
Views
337
Replies
4
Views
443

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,425
Messages
5,831,559
Members
430,075
Latest member
Tuturino

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back