Sum Up To Certain Number

[AMayland]

I am creating a spreadsheet for my credit card rewards.

Up to 1500 dollars, the card earns 5x points (Per Quarter). After that it earns 1x points.

I am trying to figure out how to calculate this. I can figure it out for the first month but then to carry it over to the next two while keeping track of the previous month is where I'm getting hung up I think

If A VBA is not necessary, IF formulas are fine.

I'm sure I'm way over thinking this process but any help would be greatly appreciated. Every time i think I have it, something is missing.

[oeldere]

It can be done with formula.

You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

[AMayland]

Will Do Now

[AMayland]

Hope this kinda clears it up...

[oeldere]

d15 =MIN($C15;1500)*5+($C15-MIN($C15;1500))*1

See the attached file (the green cells)

[AMayland]

d15 =MIN($C15;1500)*5+($C15-MIN($C15;1500))*1

See the attached file (the green cells)

Thanks! This should work, I'll implement it into those other formulas because I have multiple credit cards on this sheet so i used the SumIfs for each card. Thanks again!

Will there be a way to separate it by month still?

[oeldere]

Will there be a way to separate it by month still?

show in an excel file what you mean (including the result).