I have tried =Countif(April:May!P5,"<10") but - error !?

Try this:

=INDEX(FREQUENCY(April:May!P5:Z5,9.9999999999),1)

--
Biff
Microsoft Excel MVP


"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