C4:c20 average of i4:i20 positive numbers

[PhilipeC]

The condition of this formula is the following:


If any number from I4:I20 is positive than in the same row C4:C20 number will be considered:
So if I4=232 THAN C4=13 WILL BE CONSIDERED
if I5=-323 than C5=43 WILL NOT BE CONSIDERED


IF I4:I20 HAVE POSITIVE NUMBERS THEN THE SAME ROWS C4:C20 WILL BE CONSIDERED OR COUNTED AS A NUMBER


FINALLY I WANT THE AVERAGE OF C4:C20 ONLY FROM THE CELLS IN I4:I20 THAT IS POSITIVE NUMBERS


SUCH AS:


I4=100 C4=12
I5=-10 C5=54
I6=14 C6=78
I7=-42 C7=54
I8=28 C8=7




THAN THE C4:C20 AVERAGE OF I4:I20 POSITIVE NUMBERS IS: 100(I4)+14(I6)+28(I8)=132/3(I4,I6,I8)=47,33

 

[Scott Huish]

=averageif(i4:i20,">0",c4:c20)

 

[PhilipeC]

It didnt work. I have I4=-10,I5=11,I6=13,I7=10 ,I8=-9 AND C4=-2 than since is negative no need to average, C5=55 positive number than will be counted to average, C6 = 93, C7 = 234, C8= 5

THE FORMULA WILL AVERAGE C4=-2 IF I4=10 IS POSITIVE , C5=55 IF I6=13 IS POSITIVE AND SO ON...

IN THIS EXAMPLE:
WE HAVE:
I5,I6,I7 POSITIVE NUMBERS

THAN IT WILL AVERAGE C5,C6,C7
55,93,234=127,33

 

[Scott Huish]

That's exactly what my formula does. How is this not doing what you are expecting?

Excel 2010
	C	D	E	F	G	H	I	J	K	L
4	-2						-10			127.3333
5	55						11
6	93						13
7	234						10
8	5						-2
Sheet1

Cell Formulas
Range	Formula
L4	=AVERAGEIF(I4:I20,">0",C4:C20)