Ask Your Question
0

HOW DO YOU PROPERLY FORMAT A CELL

asked 2012-07-28 07:54:16 +0200

Gifmaster gravatar image Gifmaster
1

MY CELL LOOKS LIKE THIS "=COUNTIF(B13:B100,1)" i WANT TO REPEAT IT 5 MORE TIMES THRU COL B,C,D,E,F SOMETHING LIKE THIS =COUNTIF(B13:B100,1)(C13:C100,1)(D13:D100,1)(E13:E100,1) This Layout Does Not Work Need Help in getting it to work.

If You Can Help Much Thanks Gifmaster

delete close flag offensive retag edit

Comments

All in UPPERCASE is like shouting in the net. And make your text to be even less legible.

mariosv ( 2012-07-28 15:33:51 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2012-07-28 15:32:30 +0200

mariosv gravatar image mariosv flag of Spain
4629 20 45

Take a look to this thread.

http://ask.libreoffice.org/question/1636/countif-used-finding-words-in-multiple-columns/

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-07-28 07:54:16 +0200

Seen: 41 times

Last updated: Jul 28 '12