On Sun, 28 Feb 2010 12:37:37 -0800 (PST), Norvascom
wrote:

Hi,

I am trying to have a formula on cell A1 for example that would look
on cells D1:CT1 to see if there are any values different than 0 (in
other words not empty or equal to 0).
If there are any values different than 0, cell A1 would indicate "Row
with data" if none, it would say "Empty row".

Any help would be appreciated.
Thanks

Try this formula:

=IF(OR(D1:CT1<0),"Row with data","Empty row")

Note: This is an array formula that should be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER.

Hope this helps / Lars-Åke