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.