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)

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

formulas