Multiple Worksheet Calculation
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
|