sumif question

[lacy]

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!

 

[FSt1]

hi
the sumif function does not have a "false" argument in it so that is where
the "too many arguments" is coming from. but i am a tad confused with the
"kol" and "pkol" part. explain that further please.

Regards
FSt1

 

[lacy]

i want a sum of all the entries next to "KOL". there are a series of entries
next to "PKOL" as well that i wish to exclude. the sumif funtion is not
allowing me to exclude "PKOL".