•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculating costs using check boxes and set criteria
Previously posted on the wrong feed, so reposting in here now.
I'm looking to set up a sheet where I can track attendance to an event, but also the revenue generated from entrance fees. I've set up a simple table that lists cost pp and check box once confirmed/paid (simplified in picture).
What I then need to do is set out formula for the following:
- Calculate the total (gross) amount received. This is currently with =SUMIF($C$3:$C$7,TRUE, $B$3:$B$7)
- Calculate the actual (net) amount recieved, but this needs to have the Service Costs subtracted first, which is 6.95% of the Fee, plus an additonal £0.59. The formula I have is =SUM(SUMIF($C$3:$C$7,TRUE,$B$3:$B$7)*0.9305)-0.59 but this only subtracts the £0.59 once, whereas I need this to be per row/fee.
Any thoughts?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#formula generator