dpaton05
Wellknown Member
 Joined
 Aug 14, 2018
 Messages
 2,343
 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)