Average If
 

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.

=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
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.
.

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Howard" wrote in message
...
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.