First install this tiny UDF:

Function noformula(r As Range) As Boolean
noformula = Not r.hasformula
End Function

Then, if your data is in column A,from A1 thru A100, in B1 enter:

=noformula(A1) and copy down

Finally enter:

=SUMPRODUCT((A1:A100)*(B1:B100))
--
Gary''s Student - gsnu200832


"John" wrote:

How do I write a SUMIF fcn that will only sum the cells of a column that
contain only numbers. I do not want to include numbers that are calculated
by a formula.

I appreciate your help, -John