| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continue equation
I have an equation average equation on sheet 3 but the data is on sheet 1.
=AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2: B2000)) I want to continue on my data for vertically so it would be the exact same but instead of B2:B2000 it would be C2:C2000. Is there anyway to do this without putting in each equation into each cell. If I drag them the equation comes out wrong. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continue equation
from
=AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2: B2000)) to =AVERAGE(IF(paste_data!$CL$2:$CL$2000=1,paste_data !B2:B2000)) "mparker" wrote: I have an equation average equation on sheet 3 but the data is on sheet 1. =AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2: B2000)) I want to continue on my data for vertically so it would be the exact same but instead of B2:B2000 it would be C2:C2000. Is there anyway to do this without putting in each equation into each cell. If I drag them the equation comes out wrong. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to continue down in the same row | Excel Discussion (Misc queries) | |||
| continue VLOOKUP to next value | Excel Worksheet Functions | |||
| VB code to continue macro | Excel Discussion (Misc queries) | |||
| continue adding inventory | Excel Worksheet Functions | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Linear Mode
