I'd like to find and add all the values in a table that pertain to a specific search

**drluislee** · 03-05-2017, 03:56 PM

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!!

**etaf** · 03-05-2017, 03:59 PM

you can use a SUMIF()

=SUMIF( Range with the words in , Criteria , Range to SUM)

ie
if column A has various info including pencils
and Column B has the values

=sumif(A:A, "pencils", B:B)

or you could add a cell with the criteria in

**jeffreybrown** · 03-05-2017, 03:59 PM

What have you tried so far? I sounds as if =SUMIF(range,criteria,sum_range) is what you need.

**drluislee** · 03-05-2017, 04:05 PM

Thank you!!!

I tried Find, Mid, lookup, vlookup. I'm a total amateur, however, so I definitely wasn't looking in the right places.

**etaf** · 03-05-2017, 04:06 PM

you are welcome and thanks for the rep

**jeffreybrown** · 03-05-2017, 04:07 PM

You might find this useful

http://www.excelfunctions.net/ExcelSumif.html

I'd like to find and add all the values in a table that pertain to a specific search

LinkBack

Thread Tools

Rate This Thread

Display

I'd like to find and add all the values in a table that pertain to a specific search

Re: I'd like to find and add all the values in a table that pertain to a specific search

Re: I'd like to find and add all the values in a table that pertain to a specific search

Re: I'd like to find and add all the values in a table that pertain to a specific search

Re: I'd like to find and add all the values in a table that pertain to a specific search

Re: I'd like to find and add all the values in a table that pertain to a specific search

Thread Information

Users Browsing this Thread

Similar Threads

Search for specific values in a column, and return values of another range of cells

Sum up dollar values in a number of rows that pertain to a specific client

search/find a substring that does not contain specific alphabet in a specific position

Sum IF all the values pertain to one particular year

vb find code to find values from specific columns in excel and upload values of same row

Search, find and add the result in a specific location

Search a table to find values in rows and columns

Bookmarks

Bookmarks

Posting Permissions