•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
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#rows.com
#natural language processing for spreadsheets
#self-service analytics tools
#generative AI for data analysis
#Excel compatibility
#row zero
#financial modeling with spreadsheets
#Excel alternatives
#self-service analytics
#formula
#revenue
#SUMIF
#entrance fees
#amount received
#attendance
#gross amount
#net amount