IF statement

[twofootgiant]

Hi everyone.

I have a data entry range running from C6:AD2506.

In cell A6 i want it to say "Item." is cells C6:AD6 are all blank and just "Item" if there is any data entered on that row (wihtihn my range).

Should I compare C6:AD6 to a blank row at the bottom of the page for this? or .......

Well, how should I do it. Also where in the formula do I have to put the $$$$ marks?

[royUK]

Try

=IF(COUNTA(C6:AD6)=0,"Item","")

Can you post in the correct forum, this should be in the Functions forum.

[twofootgiant]

oops sorry.

that worked perfectly btw..thanks