Hi All
I am trying to count the number of times the letter "P" appears in the same cell reference, C3, across a number of worksheets.
The worksheets represent meeting dates and are named "Oct1", "Oct8", "Oct15", "Oct22", "Oct29", "Nov5" etc through to "Dec17".

The formula I thought should work is =COUNTIF('Oct1:Dec17'!C3,"P") but that just returns a #VALUE! error.

Anyone got any ideas about why it isn't working.

Any help gratefully received.
Many thanks.
Chris