Totalling column in Excel when cells contain forumulas
 

I do not know how to add a column of figures when the cells contain formulas

Totalling column in Excel when cells contain forumulas
 

You should just be able to sum them normally. Whether they're generated
by formulas or not makes no difference, as long as they are numbers.

Have you tried something like

=SUM(A1:A100)

If this doesn't work it might be because the "numbers" generated by
your formulas are, in fact, text. If so this can probably be rectified
by altering the formulas, can you give an example of the formulas?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528890

Totalling column in Excel when cells contain forumulas
 

You need a UDF

Function CountFormulae(rng As Range)
Dim cell As Range
Dim iLastRow As Long
iLastRow = Cells(Rows.Count, rng.Column).End(xlUp).Row
For Each cell In rng.Cells(1, 1).Resize(iLastRow)
If cell.HasFormula Then
CountFormulae = CountFormulae + 1
End If
Next cell
End Function

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joni" wrote in message
...
I do not know how to add a column of figures when the cells contain
formulas