If I have a column labeled Description (say Column B) and another labeled Expenses (Column E) in which the cost of the expense is contained, is there a way to tally only those numbers in Column E when the entry in Column B is something very specific, such as "brooms"?
E.G.:
Date Description Cost
1/1/15 dust pans 15.00
2/1/15 mops 45.00
3/1/15 mops 45.00
4/1/15 dust pans 15.00
In another field I want to total the cost of mops only, which would show the total cost to be $90. Is there a way to do that or must the table be laid out by individual types of expenses in their own column or row?
Bookmarks