•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
Our take
Tracking attendance and revenue for your event can be streamlined using checkboxes and specific formulas in your spreadsheet. To calculate the total gross amount received, your current formula, `=SUMIF($C$3:$C$7,TRUE,$B$3:$B$7)`, effectively sums confirmed payments. For the net amount, you need to account for service costs, which include a 6.95% fee and an additional £0.59 per entry. Adjust your formula to ensure the service cost is applied to each row individually, allowing for accurate net revenue calculations. Let's refine your approach
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]
Read on the original site
Open the publisher's page for the full experience
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