Hi,

COUNTIF doesn't support 3-D function references. Instead enter a countif in
each sheet in the same cell, for example D1 and then use

=SUM(April:May!D1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Al9315" wrote:

Hello
I have a stock system set up - WorksheetApril, WorksheetMay etc to March + a
final summary sheet.
I have tried =Countif(April:May!P5,"<10") but - error !?
=Countif(April!P5,"<10") - fine
=Countif(P5:Z5,"<10") - fine
I just wish to have this figure for each month in the summary sheet
Any help most welcome

Al