#### SALBOL1

##### New Member
Hello --

Another follow-up from yesterday --- I have columns that look like the following:

A B C D E F
1 Month 1 2 3 4 5
2 Promo 43 52 37 OFF OFF
3 Sales 21 20 23 25 27
4 Margin 297 632 911

I've got Margin as a cumulative number which considers sales from previous months (less a churn amount of those customers) -- and a Promotion period which will be variable in the model. In this instance, it happens to be a 3 month period. I'm trying to create a SUMIF formula to account for these varied timeframes, so that I will sum the Promo sales, apply a churn factor, and then * by a margin --- and also do the same for my regular Sales customers as well. Here's what I've tried with a SUMIF formula, but I'm getting funky results:

If In C4:

SUMIF(\$B\$2:B2,"B2>0")*(1-\$churn rate)*(\$margin)+SUMIF(\$B\$3:B3,"B3>0)*(1-\$churn rate)*(\$margin)

If in D4:

SUMIF(\$B\$2:C2,"C2>0")*(1-\$churn rate)*(\$margin)+SUMIF(\$B\$3:C3,"C3>0)*(1-\$churn rate)*(\$margin)

etc....

I know I'm being thickheaded here --- but need some help. I should probably have something that indicates if row 2 doesn't = "OFF" (promo over), but in months 4 and 5 I still have to account for the base on those customers that will churn away from those that I sold in those 3 promo months...

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Found my own answer, instead of having SUMIF(\$B\$1:G1,"G1>0"), I just replaced it with SUMIF(\$B\$1:G1,">0") and then mult by the other factors and now the formual works...dk why specifically, but it does.....

Replies
1
Views
426
Replies
6
Views
712
Replies
10
Views
1K
Replies
16
Views
577
Replies
4
Views
426

1,220,009
Messages
6,151,441
Members
451,028
Latest member
greekness1

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