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