Hi everybody. I have another one and you've all been exceptional so far.
I have an invoice chart that has a "Category" column and a "Total (after taxes)" column. At the top of the page I have individual cells in which I need the sum total of each individual category.
The categories are as follows...
-Beer
-Wine
-Liquor
-NA Bev
-Restaurant Supplies
What formula or formatting do I need to use to make a cell (call it C3) reflect the sum total of each "Total (after tax)" cell, dependent upon the information in the "Category" column.
***Note: I need one cell to contain the sum total for both "NA Bev" & "Restaurant supplies".***
Thanks in advance!
Bookmarks