IF Function.

[GEM]

How can I tell the function to not count or add a cell when there is no
information in it??

 

[Dave Peterson]

=counta() and =sum() will both ignore empty cells.

 

[Harald Staff]

=IF(A1="",0,42)

HTH. Best wishes Harald

 

[Shane Devenshire]

Hi,

SUM should not create problems, but COUNTA could. If A1 contains a formula
that returns "" then use something like this array formula:

=COUNTA(IF(LEN(A1:A10)>0,A1:A10,""))

to make it an array press Shift+Ctrl+Enter to enter it, not Enter.

If your data is all numeric there see Dave's post.