A bit more intricate, but also much more powerful are the final counting functions, COUNTIF and COUNTIFS. COUNTIF works similar to the regular IF function. 10. Open the advancedexcel308.xisx file, found in Canvas. 11. Click on the 'Accounts' tab. 12. Click in cell Ed and type 'Plus Tax'. 13. In cell EZ, enter an IFfunction that translates to: if the content of C2 (Category) is equal to "food", the tax paid is equal to zero, otherwise, the tax is equal to 20% of the Amount in D2. (make sure to include quotation marks around "food") 14. Make sure that cell EZ totals the amount PLUS the tax. 15. Set the format of cell 2 to Accounting. 16. Autofill the formula in cell EZ to the rest of column E