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.