Average If

[Guest]

I need a formula that works for =AVERAGEIF(A4:A50,0,B4:B50) I want to be able
to average one row of cells if the corsponding row shows a certen value.
If A4:A50 has a 0 in it add the corsponding cells in B4:B50 it to the cell
that the formula is in and average it by the number of cells that had numbers
were taken out of.

 

[Jason Morin]

=AVERAGE(IF(A4:A50=0,B4:B50))

Array-entered, meaning press ctrl/shift/enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
I need a formula that works for =AVERAGEIF

(A4:A50,0,B4:B50) I want to be able

 

[Arvi Laanemets]

Hi

=SUMIF(...)/COUNTIF(...)