View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Al9315 Al9315 is offline
external usenet poster
 
Posts: 6
Default Multiple Worksheet Calculation

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