dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,375
- Office Version
- 365
- 2016
- Platform
- Windows
I need some help with a formula to calculate this, I think I need a sumif formula but I am not sure.
I am trying to make a formula in a cell below the table that calculates the total GST for all services in the invoice. This is the formula I have but it won't work. Could someone tell me what is wrong with it please?
- I have a excel table that calculates costs of services.
- The table is called npss_quote.
- There is a totals column called "Price ex. GST".
- There is a drop down menu with 5 services and the header for this column is Service
- There is one service that does not attract GST.
- GST is a tax in Australia.
- GST is a flat 10% of the cost of the item.
- I can't use fixed references as there could be x number of rows in the table.
I am trying to make a formula in a cell below the table that calculates the total GST for all services in the invoice. This is the formula I have but it won't work. Could someone tell me what is wrong with it please?
Code:
=SUMIF(npss_quote[Service], " <>*Activities", npss_quote[Price
ex. GST]*0.1)