# Sumproduct Formula

#### krunk

##### New Member
Hi,

I am trying to adjust my sumproduct formula to alway add in the next months totals. Below is a better example.
 Partner Reported Take Rate Partner Reported Ticketing Transactions Jan 7.32% 833,580 Feb 7.22% 741,607 Mar 0.00% 0 Apr 0.00% 0 May 0.00% 0 Jun 0.00% 0 Jul 0.00% 0 Aug 0.00% 0 Sep 0.00% 0 Oct 0.00% 0 Nov 0.00% 0 Dec 0.00% 0 7.24% = SUMPRODUCT(\$C\$3:C4,\$B\$3:B4)/SUM(\$C\$3:C4)

<colgroup><col style="width: 48pt;" span="3" width="64"> <tbody>
</tbody>

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### RonB1111

##### Well-known Member
Try:
=SUMPRODUCT(\$C\$3:C14,\$B\$3:B14)/SUM(\$C\$3:C14)

#### krunk

##### New Member
Didn't work when there are values already in the cell. i think it needs to be a sumproduct with an if statement.

Try:
=SUMPRODUCT(\$C\$3:C14,\$B\$3:B14)/SUM(\$C\$3:C14)

#### RonB1111

##### Well-known Member
It works properly in my test. I had the 7.32% in B3 and the 833,580 in C3. 7.22 was in B4 and 741607 in C4. Dec was in row 14. B5 thru C14 were zeros. If it still does not work for use in this layout, please provide specifics on your setup and please clarify with some more sample data showing what you're trying to achieve.

Replies
4
Views
144
Replies
2
Views
82
Replies
1
Views
81
Replies
5
Views
223
Replies
2
Views
152

1,195,918
Messages
6,012,297
Members
441,690
Latest member
CyberWrek

### 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.

### Which adblocker are you using?

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

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