Try
=IF(SUM(IF(ISNUMBER(B7:B94),B7:B94)),SUM(IF(ISNUMB ER(B7:B94),B7:B94)),NA())



"BNT1 via OfficeKB.com" wrote:

Hi Sheeloo

Tried new workbook and with suggested formula, (sumproduct) but still
showing 0

{=sum(if(isnumber(B78:B94),B78:B94))}

do you know if the above formula can be altered to show #n/a if non of the
cells in the range contain a value, but will sum any values in that range?

regards

Sheeloo wrote:
I had suggested

=IF(SUMPRODUCT(--(B78:B94<0), (B78:B94)),SUMPRODUCT(--(B78:B94<0),(B78:B94)),"#N/A")

Did you try that AFTER changing NA() to #N/A in your formulae?
Test it out on a new sheet with few cells

Hi Sheeloo

[quoted text clipped - 18 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200810/1