Count Blanks on Excel

  AJ28 19:28 23 Nov 2003
Locked

Using the function 'COUNTBLANK' on excel it doesnt want to work using is on more than 1 sheet. I want to count singular cells on quite a few different worksheets, but its not happening using 'COUNTBLANK' can anyone help?

  VoG II 17:32 25 Nov 2003

Something like this should work:

=COUNTBLANK(Sheet2:Sheet6!$A$2:$C$5)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?