| View previous topic :: View next topic |
| Author |
Message |
broneedsomehelp
Newbie
Joined: 10 Nov 2011
Posts: 2
|
 Posted: Thu Nov 10, 2011 9:42 am Post subject: Getting number of rows from another tab |
 |
|
| Using the COUNT() function, how I do get information from Tab 3 to be placed in Tab 1? |
|
| Back to top |
|
 |
sainttomn
OOo Enthusiast
Joined: 18 Feb 2011
Posts: 131
Location: Two gangster planets and a cowboy world
|
| Posted: Thu Nov 10, 2011 1:01 pm Post subject: |
|
|
You can accomplish this by referencing the other tab (sheet) in the COUNT statement. Something like this should work:
COUNT(Sheetname.value1; value2; ... value30)
_________________
"I'm a loner, Dottie. A rebel."
[Windows 7] [OO.o 3.3] [HSQL 1.8]
The Lazer Cat |
|
| Back to top |
|
|
broneedsomehelp
Newbie
Joined: 10 Nov 2011
Posts: 2
|
| Posted: Thu Nov 10, 2011 1:40 pm Post subject: [SOLVED] Getting number of rows from another tab |
|
|
Thank you ...
=COUNT('Sheet name in single quotes'.B2:B12) |
|
| Back to top |
|
|
|
