Does COUNTIF span multiple Tables?

The following is from pg 39, of Forumlas_and_Functions_USer_Guide.pdf" :

Some functions that accept ranges can operate on ranges that span multiple tables.


I can't get COUNTIF to accept multiple tables.....


I pasted about 45 tables from a word document into a numbers document, and it created the 45 Tables.

They all have the same structure 3 columns and row 1 contains the column headers.


For example:

Table 1


# Element
Description
1 Button is but
2 Image is photo
3 Image is graphic

Table 2



# Element
Description
1 Button is but
2 Button is click
3 Image is graphic



I want to create a single table that basically 'counts' the number of cells that contain a specific Element:


I can get the COUNTA function to span multiple tables...

=COUNTA(Table 1:Table 2 :: B) (would show 8)

But

=COUNTIF(Table 1:Table 2 :: B, "=Button") (shows 0)




Does COUNTIF span multiple tables? if why does it not work... I've tried a number of different 'conditions'...

if not... is there anoter way to create a table full of totals from multiple tables?


thanks

drew

Numbers 09-OTHER, Mac OS X (10.7.3)

Posted on Mar 21, 2012 12:06 PM

Reply
3 replies

Mar 21, 2012 12:56 PM in response to sanbeaman

I've used this app for ages and I never knew that any functions spanned multiple tables in the way you are doing it. But it does seem to work with COUNTA and SUM (and maybe some others). Note that the order of the tables in the sidebar is important, if you have a Table A inbetween Tables 1 & 2 in the sidebar, it is included too.


Is this a documented feature or did you come up with that on your own? If it is undocumented, I wouldn't expect it to work consistently.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Does COUNTIF span multiple Tables?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.