Try in say, D1: =SUMIF(C:C,"100")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Tracey" wrote:
How do I get to sum numbers greater than 100 in a column which has various
numbers for example:

C1 = 50
C8 = 120
C15 = 20
C25 = 200

how do I get it to ad C8 and C25 only?
The sheet has over 1000 rows