| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif and average with limits... pls help....
I need to average a group of data with a criteria but only up to a certain
number. Sample: CD AG CD FG CD FG AG 50 20 10 30 60 40 80 I need to average the data that is under "CD" but ONLY the first 2..(50 and 10). How can I set the limit?? (btw, I will be using Hlookup to get the "CD" criteria) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there formula similar to SUMIF that will work for average | Excel Discussion (Misc queries) | |||
| SUMIF for an AVERAGE | Excel Worksheet Functions | |||
| Average/Sumif based on several columns | Excel Worksheet Functions | |||
| Average/Sumif based on several columns | Excel Worksheet Functions | |||
| Weighted average using SUMIF and/or SUMPRODUCT | Excel Discussion (Misc queries) | |||
Threaded Mode
