Kiến thức

COUNTBLANK on multiple sheets

R

Bạn đang xem: COUNTBLANK on multiple sheets

rickblunt

Active Member

Joined
Feb 18, 2008
Messages
486

  • 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
Close
Back to top button