| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding an average with the lookup function
Hi,
Am Fri, 27 Jan 2012 20:54:49 +0100 schrieb Claus Busch: =SUMIF(F19:F55,F56,C19:C55)/COUNTIF(F19:F55,F56) if you use xl2007 or higher, you can also try: =AVERAGEIF(F19:F55,F56,C19:C55) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the average using conditions in a logic function - problem | Excel Discussion (Misc queries) | |||
| I need help finding an average | Excel Discussion (Misc queries) | |||
| Average using lookup function | Excel Discussion (Misc queries) | |||
| Calculate the average using the Lookup function or similar | Excel Discussion (Misc queries) | |||
| Lookup Ques - finding value within a string to lookup | Excel Programming | |||
Threaded Mode
