1 min readfrom 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:

  1. Calculate the total (gross) amount received. This is currently with =SUMIF($C$3:$C$7,TRUE, $B$3:$B$7)
  2. 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.

https://preview.redd.it/7ln6646rz3yg1.png?width=487&format=png&auto=webp&s=e9f2283823da6e0a68945cf865ff0ab75bb95117

Any thoughts?

submitted by /u/i_am_smedley
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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