I'm making an itemized list of everything I buy for the month. My spreadsheet shows a label in the left cell and the cost of the label to the right of it. Like this:
So I want Excel to detect the text "Junk Food" from A1, A2, and A4 and automatically add it's corresponding cost (From B1, B2, B4) into B6. This way I won't have to enter "=sum(" then manually click Ctrl + B1, B2, and B4 every time I add a new item of Junk Food. I want the output of A6 to only show how much I spent on Junk food.Please Login or Register to view this content.
Bookmarks