Prev: Need help with if function
Next: Auto updating muiltiple spreadsheets in Excel 2007
From: r2rcode on 17 May 2010 13:51
i need to calcuate the number of columns that have a value greater than zero
within a particular row.
From: Luke M on 17 May 2010 13:54
As stated in your previous thread:
=COUNTIF(A2:Z2,">0")

--
Best Regards,

Luke M
"r2rcode" <r2rcode(a)discussions.microsoft.com> wrote in message
news:4381E2C3-9F78-403C-9B6E-3737C62C427F(a)microsoft.com...
>i need to calcuate the number of columns that have a value greater than
>zero
> within a particular row.


 | 
Pages: 1
Prev: Need help with if function
Next: Auto updating muiltiple spreadsheets in Excel 2007