SUMIF

[Tracey]

Hi

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

Many thanks
Tracey

 

[Max]

Try in say, D1: =SUMIF(C:C,">100")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[Jarek Kujawa]

one way:

=COUNTIF($C$1:$C$2000,">"&100)

 

[Jarek Kujawa]

sorry, I misread yr post