Countif Function

[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!!!!!

 

[Fred Smith]

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

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

Regards,
Fred.