I’m trying to use the function with the following formula:

=SUMIF(B2:B10,”Tanken”,C2:C10)

I keep getting the, “There’s a problem with this formula”, error message.

When I close the message, the formula is highlighted from B10 through C2.

I have no idea why. According to every tutorial I have watched, the format is correct.

Any help would be greatly appreciated.

​I’m trying to use the function with the following formula:=SUMIF(B2:B10,”Tanken”,C2:C10)I keep getting the, “There’s a problem with this formula”, error message.When I close the message, the formula is highlighted from B10 through C2.I have no idea why. According to every tutorial I have watched, the format is correct.Any help would be greatly appreciated.  Read More

​