Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct...Average
I have 12 different tabs. I want to average a number on each tab only if the
number is greater than zero. So, on tab 1 cell b6=140, tab 2 b6=245, tab 3 b6=0 and so on with b6 on each tab having a number greater than 0 sometimes. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average using Sumproduct | Excel Worksheet Functions | |||
Average while using SumProduct | Excel Worksheet Functions | |||
SUMPRODUCT to average | Excel Worksheet Functions | |||
Sumproduct Average | Excel Discussion (Misc queries) | |||
sumproduct & average | Excel Worksheet Functions |