| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If function and math formulas
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Math formulas possible with overstrike characters? | Excel Discussion (Misc queries) | |||
| Math Function? | Excel Discussion (Misc queries) | |||
| Need help with math Function | Excel Worksheet Functions | |||
| Excel Math formulas | Excel Discussion (Misc queries) | |||
| need list of free math formulas in excel | Excel Worksheet Functions | |||
Threaded Mode
