I am trying to sum up all values in column B when column A contains the word “apple” in its adjacent cell.
Column A contains fruits, e.g. apple1, apple2, cherry etc. In column B its corresponding price is listed.
To get the sum of all apple types, I use
=SUMIF(A1:A6,"*apple*",B1:B6)
However, this does not work successfully as I always receive 0. Where is the mistake?
