Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averaging on an "if" or "sumproduct"
I have the following:
Column A has names, column B has numbers. I want to average the numbers in column B, only if the name is "Nick". Thanks for any help you can give! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averaging on an "if" or "sumproduct"
Nancy, Type in this formula where you want the result. =AVERAGE(IF(A2:A8="Nick",B2:B8,"")) This is an array formula so commit with Ctrl-Shift-Enter which will result in {=AVERAGE(IF(A2:A8="Nick",B2:B8,""))} Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=491554 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averaging on an "if" or "sumproduct"
=AVERAGE(IF(A2:A20="Nick",B2:B20))
as an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "Nancy" wrote in message ... I have the following: Column A has names, column B has numbers. I want to average the numbers in column B, only if the name is "Nick". Thanks for any help you can give! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging function is pulling back a zero in Excel | Excel Discussion (Misc queries) | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
Averaging | Excel Discussion (Misc queries) | |||
Averaging noncontiguous numbers ignoring zeros? | Excel Worksheet Functions | |||
2 part question on averaging | Excel Discussion (Misc queries) |