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!

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!

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" 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!

Just a closer look at your 1st expression ..
=sumif(D2:AG50000,AH153,Z2:Z50000)
Think your multi-col range D2:AG50000 is wrong. It has to be a single col
range, eg D2:D50000. That SUMIF accepts it (the multi-col range) doesn't mean
that it works that way. Only D2:D50000 is operative in your SUMIF expression,
the rest of the cols E, F, ... AG are plain ignored in the evaluation. If you
check with some test data carefully, you'd see this. Do the correction first,
then you would be clearer in what is your actual issue at hand.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"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!

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".

"FSt1" wrote:

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" 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!