| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average if - data on separate sheet
I am trying to calculate the average of 5 questions if another question responded 1 or 2, this equation keeps bringing up 0. The data is on another worksheet in my workbook. The worksheet is called paste_data. =AVERAGE(IF((paste_data!CL2:CL2000=1 or 2),paste_data!B2:F2000)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to reorganize data on a separate sheet possibly using vlookup | Excel Worksheet Functions | |||
| Frame an Invoice from the data available in a separate sheet of excel | Excel Worksheet Functions | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| vlookup formula not working with data on separate sheet | Excel Worksheet Functions | |||
| combo box from data validation with source list in separate sheet | Excel Worksheet Functions | |||
Threaded Mode
