Thread: In 3 active sheets in wkbk, determine& display the # of sheets that have data

I am wking with potentially 3 active sheets in a wkbk i.e. anyone of them or all could have data or text entered in them at any time. This is an ever changing scenario as data is entered or deleted i.e. a sheet is filled and the next sheet receives the new data etc. Since I am able or only want to see one sheet at a time, it is necessary to see on the displayed sheet how many of the 3 sheets have data on them at anyone time and to display that # of sheets numerically on all 3 sheets as I move thru them. I guess most simply stated I would like to know when I am in sheet #1 whether 1sheet is filled with by putting the #1 in sheet one or if 2 sheets have data by putting the #2 in sheet 1 & sheet 2 & sheet 3 & to reflect that # on any sheet I am viewing
I need to test only cell "B3" on each sheet to determine if a sheet has data but the counting formula across all 3 sheets stumps me
-the 3D reference concept will not let me accomplish that task
-Thanks for the help -vty wrpalmer

try this

=IF(ISBLANK(Sheet1!B3),0,1)+IF(ISBLANK(Sheet2!B3),0,1)+IF(ISBLANK(Sheet3!B3),0,1)

"wrpalmer" wrote:

>
> I am wking with potentially 3 active sheets in a wkbk i.e. anyone of
> them or all could have data or text entered in them at any time. This
> is an ever changing scenario as data is entered or deleted i.e. a
> sheet is filled and the next sheet receives the new data etc. Since I
> am able or only want to see one sheet at a time, it is necessary to see
> on the displayed sheet how many of the 3 sheets have data on them at
> anyone time and to display that # of sheets numerically on all 3
> sheets as I move thru them. I guess most simply stated I would like to
> know when I am in sheet #1 whether 1sheet is filled with by putting the
> #1 in sheet one or if 2 sheets have data by putting the #2 in sheet 1 &
> sheet 2 & sheet 3 & to reflect that # on any sheet I am viewing
> I need to test only cell "B3" on each sheet to determine if a sheet has
> data but the counting formula across all 3 sheets stumps me
> -the 3D reference concept will not let me accomplish that task
> -Thanks for the help -vty wrpalmer
>
>
> --
> wrpalmer
> ------------------------------------------------------------------------
> wrpalmer's Profile: http://www.excelforum.com/member.php...o&userid=25347
> View this thread: http://www.excelforum.com/showthread...hreadid=482158
>
>