I'd like to find and add all the values that pertain to a specific search.
In other words, in my large excel table of itemized receipt, I have purchased "Pencils" may different times at different prices. This is all recorded in a table.
I'd like to write a function in excel that will automatically search each cell in the table for "Pencils," return the price of "Pencils" that's written in a different column, and add all these values up.
This will save me a lot of time instead of needing to go through each and everyone individually!
Please help!!
Bookmarks