ExcelBanter - SUMIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF (https://www.excelbanter.com/excel-worksheet-functions/211054-sumif.html)

Tracey

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

Max

SUMIF

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

Jarek Kujawa[_2_]

SUMIF

one way:

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

Jarek Kujawa[_2_]

SUMIF

sorry, I misread yr post

All times are GMT +1. The time now is 10:14 PM.