Jun 14 2018 12:18 PM
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.
Jun 14 2018 12:46 PM
In Excel ? there isn't a function called sumwhen, aren't you looking for countif ?
=countif(k2:k92, "EZ")
Jun 14 2018 01:51 PM
Well, I have reviewed the formular as you suggested and it works
Many thanks