Multiple IF statements in a formula

[naquin316]

Hi. I have a field ticket spreadsheet with 6 possible pages to print. There will always be a page 1 of the ticket and could possibly be up to 6 pages. I have cells on all 6 pages that say "page 1 of (blank)" where page 1 of would be cell K6 of each sheet and (blank) would be M6 of each sheet.


If there is data in E12 for pages 2 up to 6 I would like the blank to show the page # of the highest # sheet that shows data. If there is no data I would like the blank to remain blank and not show #REF.


I've attached a link to download the spreadsheet.

http://speedy.sh/skSeC/upload-if-statement.xls

 

[Hui]

Naquin316


How about in S01!M6 using:

=COUNTA(SO1:SO6!$E$12)

 

[naquin316]

Perfect! Works like a champ. Thanks!