Nesting If with Counta and Countif

=IF(COUNTA(PartsData!AG2:AI2=0),"", IF(COUNTIF(PartsData!AG2:AI2,"LD")>=1,"1 - Yes","2 - No"))

The above formula is supposed to do the following:


1) If Cells Ag2:AI2 contain no data at all then forget the whole thing and leave the formula cell blank
2) but if at least one of those cells is filled, and if at least one of those filled cells says "LD", then return the value '1 - yes'.
3) Whereas if at least one of those cells is filled but none say "LD", then return "2 - no"

I'm not getting any error messages - but the cell is blank when it shouldnt be

Can anyone help?

Thanks,
Henry

Awesome, thanks Olly - it works now as you anticipated.

Nice to know I wasn't a million miles off!

Repped.