sumif question
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!
|