sumwhen

Highlighted
Occasional Contributor

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.

3 Replies
Highlighted

In Excel ? there isn't a function called sumwhen, aren't you looking for countif ?

 

 

=countif(k2:k92, "EZ")

Highlighted
Thanks I will check it
Highlighted

Well, I have reviewed the formular as you suggested and it works

Many thanks