Hi
=SUMIF(A:A,"*OLA",B:B)

--
Regards
Frank Kabel
Frankfurt, Germany
"carl" schrieb im Newsbeitrag
...
I tried modifying my SUMIF formula to sum if the data in COLK contains
"OLA".
The modifiaction does not appear to work.

If OLA does appear in COLK, it will always be the right 3 characters.

Can my formula be modified to sum if COLK has OLA in the right 3
characters ?

Thank you in advance.