Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tracey Tracey is offline
external usenet poster
 
Posts: 78
Default SUMIF

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