| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average same cell in multiple sheets
Hi there --
I have a workbook with a tab for each month (i.e. Jan, Feb, Mar...Dec). I need to AVERAGE CT19 in each. And, I don't want to include any that are 0. So, I've tried the following, but it doesn't work. (I have tried this both as an array and not an array.) =AVERAGE(IF(Jan:Dec!$CT19<0,Jan:Dec!$CT19) Any suggestions? Thanks so much. Ellen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the average across multiple sheets | Excel Worksheet Functions | |||
| 1 cell average across multiple worksheets | Excel Worksheet Functions | |||
| How do I add (=Sum) the same cell for multiple sheets (103) | Excel Worksheet Functions | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
| Cell Reference, Multiple Sheets | Excel Worksheet Functions | |||
Threaded Mode
