| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
New Member
Join Date: Mar 2011
Posts: 1
|
Hello,
I am getting an error (#DIV/0!) for my averageifs formula. I can not seem to get it to work. In column A I have last names and in Column B I have Amounts. I am trying to get the average for each person's name in column "A". Below is what my formula looks like: =AVERAGEIFS($B$4:$B$18,$A$4:$A$18,"Anderson",$A$4:$A$18,"Back"). Please help!!! Thanks NM 
|
|
|
|
|||
|
|
| |
|
Silly Fool
Join Date: Jun 2010
Posts: 1,796
|
Welcome to the forum Nadipatrick
 You would probable get more help if you let people know you are using MS Excel Edit: have a look at the link and see if its any help http://support.microsoft.com/kb/182188 
|
|
||
|
|
||||
|
@ 4.2Ghz
Join Date: Jan 2005
Location: 127.0.0.1
Posts: 8,864
|
If someone knows the answer, i'm fairly certain they'd be able to tell thats and excel formula, though its a little above me i'm afraid.
 You could try the newsgroups. 
  Gigabyte EX58-UD5 | Intel i7 @ 4.2Ghz under a Noctua NH-U12P | 6GB Corsair XMS DDR3 Gigabyte GTX670 | Creative X-FI Titanium HD | Crucial M225 128GB SSD + 3TB's of Storage Corsair HX850 | Logitech G19 & G25 | Razer Deathadder Respawn | Wireless Xbox 360 Pad Samsung 2443BW | Lian Li PC-7FW | Acoustic Energy Aego M | Windows 7 Ultimate 64 Bit |
|
||
|
|
||||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| AVERAGEIFS Error | ianwillo123 | Microsoft Excel Worksheet Functions | 0 | 12th Nov 2010 02:21 PM |
| Can I use AVERAGEIFS? | JRD | Microsoft Excel Worksheet Functions | 2 | 28th Nov 2009 11:33 PM |
| Re: Can I use AVERAGEIFS? | Pete_UK | Microsoft Excel Worksheet Functions | 0 | 28th Nov 2009 07:33 PM |
| Re: Can I use AVERAGEIFS? | JoeU2004 | Microsoft Excel Worksheet Functions | 1 | 28th Nov 2009 06:47 PM |
| AverageIFs | mhouseit | Microsoft Excel Discussion | 4 | 25th Apr 2009 10:26 AM |
