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


--
wrpalmer
------------------------------------------------------------------------
wrpalmer's Profile: http://www.excelforum.com/member.php...o&userid=25347
View this thread: http://www.excelforum.com/showthread...hreadid=482158

In 3 active sheets in wkbk, determine& display the # of sheets tha
 

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