Fola

[sbog]

New to playing with formulas. Can someone help me to write a formula that would basically state:

If c5:c15 has a value equal to 1 or greater then the value of each cell in c5:c15 would be returned as .25 and then all the values returned of .25 would be added to a sum?

 

[dreid1011]

Welcome to the forum. I feel like something is missing. If C5:C15 values are equal to 1 or greater than C5:C15 values (themselves?) then return .25. Then sum all of the .25 values?

Comparing the values to themselves in this case doesn't make much sense. Perhaps you meant to type a different range for the greater than comparison?

 

[Asbestos_Jen]

Is this what you're looking for?

Book1
	C
5	4
6	1
7	0
8	0
9	4
10	6
11	0
12	2
13	6
14	3
15	0
16
17	1.75
Sheet1

Cell Formulas
Range	Formula
C17	C17	=COUNTIF(C5:C15,">=1")*0.25

 

[awoohaw]

maybe this:

Book1
	A	B	C	D
1
2
3
4
5			-11	1.25
6			19
7			2
8			25
9			19
10			4
11			-15
12			-3
13			-3
14			-5
15			-3
Sheet1

Cell Formulas
Range	Formula
D5	D5	=SUM(IF(C5:C15>=1,0.25,0))

 

[sbog]

Is this what you're looking for?

Book1
	C
5	4
6	1
7	0
8	0
9	4
10	6
11	0
12	2
13	6
14	3
15	0
16
17	1.75
Sheet1

Cell Formulas
Range	Formula
C17	C17	=COUNTIF(C5:C15,">=1")*0.25

Yes, perfect, thanks for the quick reply and I see what I was doing wrong! Thanks so much!

 

[Asbestos_Jen]

Glad to help. Thanks for the feedback.