SUMIFS Formula Help

TimM

New member
Joined
Dec 16, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Version 11
I want to create a spreadsheet which calculates the cost of some advertising (see attachment)


The base price of £522 in Cell A2 is for 300,000 impressions.
I want the user to be able input the exact number of impressions in cell B2 and for every additional 300,000 impressions, I want to add £128 to add it all up to a total cost in Cell C2.


I think I need a SUMIFS formula, but not sure how to do this.
Can anyone suggest a formula I need?


thanks
 

Attachments

  • XL.PNG
    XL.PNG
    15.1 KB · Views: 10
A bit of a guess; in cell C2:
Code:
=A2+(ROUNDUP(B2/300000,0)-1)*128
?
 
Back
Top