Matching Text and return total values

**Mikejx2** · 08-02-2021, 11:08 AM

Hello,

I am trying to write a formula that will look at the names on sheet 1 (C8:J18) and if they match the names on sheet 2 (B3:C39) then sum the price that associated with each name in cell J1 (Sheet 1)

**wk9128** · 08-02-2021, 11:33 AM

Try this formula

HTML Code:

**CARACALLA** · 08-02-2021, 03:42 PM

Sheet 1

J1=SUMPRODUCT(SUMIF('Sheet 2'!B3:B39,'Sheet 1'!C8:J18,'Sheet 2'!C3:C39))

Matching Text and return total values

LinkBack

Thread Tools

Rate This Thread

Display

Matching Text and return total values

Re: Matching Text and return total values

Re: Matching Text and return total values

Thread Information

Users Browsing this Thread

Similar Threads

Lookup Multiple Values Across Columns and Return All Matching Values from a Single Column

[SOLVED] IF Column Contains Text Matching Another column then return Values from second sheet.

matching text within 2 columns of 2 different worksheets to return row values in a 3rd wor

Find a text and return the sum of values in adjacent cells matching the text in range

[SOLVED] Return cell values for non-matching & matching criteria

Creating a total (sum) of items matching a text value

Excel 2007 : Excel 2007 - Formula to return value based on matching of two separate text values

Bookmarks

Bookmarks

Posting Permissions