math applications and formulas
 

I need help with following math application:

I have two rows of values. Values in row 2 will change according to the
changes in row 1. The change pattern is: average of those values in row 2
*3+3 when the values in row 1 =0.

I tried the formula: =IF(COUNTIF(A1:Z1,0),AVERAGE(A2:Z2)*3+3,1). It did not
work. Please help.

Thank you,
Linda

math applications and formulas
 

Firstly, I think your problem is not well stated.
Secondly, you should probably post this in either the
Microsoft.Public.Excel.Worksheet.Functions or
Microsoft.Public.Excel.Worksheetfunctions newsgroups.
This newsgroup is supposed to be reserved for VBA programming posts.

--
Regards,
Bill Renaud