Totalling column in Excel when cells contain forumulas

[Joni]

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

[daddylonglegs]

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?

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> I do not know how to add a column of figures when the cells contain
formulas