Kiến thức

COUNTBLANK on multiple sheets


Bạn đang xem: COUNTBLANK on multiple sheets


Active Member

Feb 18, 2008

  • Jan 22, 2010

  • #1

Greetings,I have a workbook that contains 62 worksheets that are used for daily inspections. Each worksheet is slightly different in the amount of cells used per day, but the same row is used on each sheet. Because there are a total of 620 cells used each day I would like to us a simple COUTNBLANK formula to confirm that every cell has it’s respective value entered. This is pretty simple of course, but as I was writing the formula and typing in =COUNTBLANK(Sheet2!K12:K17+Sheet1!K13:K18+Sheet3!K11:K21+…..) I got to thinking, “Is there a better way of doing this instead of typing in all 62 sheets?”. Thanks,RB

Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Back to top button