To use SUMIF, place your cursor where you would like the sum calculated for a particular type of audit. In the invoice in the screenshot below, I have placed my cursor in cell C46 to calculate a sum ...

M any use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional ...