=if(counta) problem

[paul w]

i have a work book with 3 sheets named pages 1, 2 and 3, in (page1), cell AU1, i have a formula that changes the text from "1 of 1" to "1 of 2", if data is entered in (page2).
=IF(COUNTA('PAGE2'!D6:X38)=0,"1 OF 1","1 OF 2")

i need it to check (page 3) same cell range, and return "1 of 3" if data is entered.

 

[paul w]

Nearly there but it needs to say "2of2" if page 3 isnt used
and "2of3" if page three is used,
thanks for your help so far

 

[Willmonbo]

I just looked at it again, looks like I completely messed it up for you, that happens when you try to multi task.

=if(COUNTA(D6:X38)=0,"",IF(COUNTA(Sheet3!D6:X38)>0,"2 OF 3","2 OF 2"))

sorry if you got confused.

 

[paul w]

thankyou very much, it works like a dream, seems a lot of work, to just change a couple of page numbers, i will have to make sure i copy them down somewhere, dont want to go through that again, once again thank you.

paul w