Prev: excel
Next: Looping Format
From: r2rcode on 17 May 2010 11:39
i need a formula that will look at the information in a range of column
within a row. if the number in a column is greater than zero, then i need to
add one to the total. this will allow me to know the number of columns with
values greater than zero.
From: Luke M on 17 May 2010 12:35
=COUNTIF(A2:Z2,">0")

--
Best Regards,

Luke M
"r2rcode" <r2rcode(a)discussions.microsoft.com> wrote in message
news:3C5B05F0-39E5-49F7-B93C-45F70851AD50(a)microsoft.com...
>i need a formula that will look at the information in a range of column
> within a row. if the number in a column is greater than zero, then i need
> to
> add one to the total. this will allow me to know the number of columns
> with
> values greater than zero.


 | 
Pages: 1
Prev: excel
Next: Looping Format