Search code examples
google-sheetscriteriasumifs

How can I use the sumif function with criteria beeing exact text from another cell?

Google sheets. So, I want to add cells that contains EXACT text from B3.

I use the function

=SUMIF ('Sheet2'!B:B, "* "&B3&"* ",'Sheet2'!D:D)

it works ok, but when the ('Sheet2'!B:B) contains text MOR it adds up. I want it to add up only cells containing exact matching cells that have MORNING.

Hope someone knows a solution.

Thanks!

Solution

  • Remove *

    =SUMIF('Sheet2'!B:B, B3 ,'Sheet2'!D:D)