Countif Function

  • Thread starter Thread starter VLH
  • Start date Start date
V

VLH

Greetings Smart Excel Users,
Will Excel allow me to create a range using multiple worksheets in a
workbook? For example, my workbook contains 4 sheets. Can I setup my
function to count within all 4 sheets or will it only allow me to count
within a single sheet?

Thanks a bunch!!!!!
 
No. Countif does not handle 3D ranges. You will need to use somthing like:

=countif(sheet1!...)+countif(sheet2!...)+countif(sheet3!...)+countif(sheet4!...)

Regards,
Fred.
 
Back
Top