Sumproduct Formula

[krunk]

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>

 

[RonB1111]

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

 

[krunk]

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]

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.