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