Re: [libreoffice-users] COUNTIF() with more than one conditions

What I would do is to add a column, fill it with AND() statement to mark
row to add or not, hide it, then use a COUNTIF() using this column as a
condition.

As far as I know, the COUNTIFS() function should do the job but for some
reason I have difficulties to make it works right now :\ you might want to
look into it.

-- 
Cley Faye
http://cleyfaye.net

2016-01-26 20:20 GMT+01:00 csanyipal <csanyipal@gmail.com>:

> Hi,
>
> in a range I have characters: "H", "K", "Sze", "Cs", "P" so so in each cell
> there is just one of these characters.
>
> I want to count howmany cells are in a range that contains either of these
> characters.
>
> Can I do this in a more elegant way than by using this function bellow?
>
>
> =COUNTIF(C152:C228;"=H")+COUNTIF(C153:C229;"=K")+COUNTIF(C154:C230;"=Sze")+COUNTIF(C155:C231;"=Cs")+COUNTIF(C156:C232;"=P")
>
>
>
>
> -----
> Best Regards from
> Pál
> --
> View this message in context:
> http://nabble.documentfoundation.org/COUNTIF-with-more-than-one-conditions-tp4173143.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted