2*3+3 = 9 for me. So

=sumif(A1:Z1,0,A9:Z9)/Countif(A1:Z1,0)

--
Regards,
Tom Ogilvy


"Linda" wrote:

I need help with the if fuction math formulas for the following situation in
my spread sheet:

I have two rows of values. Values in row 1 correspond to the values in row
2. I need to count the number of 0 in row 1 and average the corresponding
values in row 2*3+3. I try the formula:
=IF(COUNTIF(A1:Z1,0),AVERAGE(A2:Z2)*3+3, but it did not work.

Please help.

Thank you,
Linda