Ok, as it's an ongoing thing i'm still really stumped! Ive tried the formula
evaluation which says it's fine, ive broken it down in notepad and it looks
fine, ive made sure the criteria are identical to how the text appear in the
source cells....but the following formula just won't work!
=SUM(IF(MOD(ROW('2008 Errors'!$A$3:$A$3000),10)=3,IF((YEAR('2008
Errors'!$A$3:$A$3000)=2008)*(MONTH('2008 Errors'!$A$3:$A$3000)=1)*(LEN('2008
Errors'!P3:P3000)-LEN(SUBSTITUTE('2008 Errors'!P3:P3000,"Kirkby
Thore","")*(LEN('2008 Errors'!B3:B3000)-LEN(SUBSTITUTE('2008
Errors'!B3:B3000,"Phone",""))))0),1)))

I'm utterly stumped as it appears fine, but is producing #VALUE! - am i
being daft and missing something in Excel where three criteria is done in
another way? I'm just looking for IF (cells are January)&(cells say "Kirkby
Thore")&(cells say Fax)=1..?
Any ideas?