Hi,

You can also use this formula. I5:I7 holds the sheet tab names - April,
May, June.

=SUMPRODUCT(COUNTIF(INDIRECT(I5:I7&"!P5:Z5"),"<10" ))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Al9315" wrote in message
...
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