View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Norvascom Norvascom is offline
external usenet poster
 
Posts: 21
Default check if any values on row

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