Forum Discussion
sumwhen
Hallo together, I have an table which in the row are "EZ" or "DZ" and I like counting the EZ and DZ. with the formula for EZ:
=SUMWHEN(K2:K92;"EZ";1;sum(K2:K92)). I got a warnung "too many argumenst for this function".
What is wrong of this formula?
Many thanks for your support.
- Thanks I will check it
Well, I have reviewed the formular as you suggested and it works
Many thanks
In Excel ? there isn't a function called sumwhen, aren't you looking for countif ?
=countif(k2:k92, "EZ")
