Thread
:
formula returning incorrect blanks
View Single Post
#
5
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
formula returning incorrect blanks
You've got a couple of active threads elsewhere.
wrote:
Problem:
When I enter the following equation into a cell with a blank in cell
CH12 or CH13 I get the correct answer (the sum of the cells with
numbers in them) but when there is a blank in cell CH14 I get an
incorrect answer (in the form of a clank cell).
=IF(AND(ISNUMBER(CH12:CH14)),SUM(CH12:CH14),"")
Does anyone have any suggestions?
Thanks,
Elaine
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson