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 <csanyi...@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+unsubscr...@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+unsubscr...@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