try this

=SUMIF(D2:AG50000,"*"&AH153&"*",Z2:Z50000)

this will give you the number of "kol" including "pkol" or "akol"
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"lacy" wrote:

i have a sumif formula that keys off of a cell with "kol" in it. included in
the reference table along with "kol" is "pkol". i tried to change the
formula from =sumif(D2:AG50000,AH153,Z2:Z50000) to
=sumif(D2:AG50000,AH153,Z2:Z50000, false) to solve the problem and the return
is "too many arguments". any ideas? thanks!