Thread: Help Required using SUM function with Vlookup
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Help Required using SUM function with Vlookup
hi,

Am Tue, 5 May 2015 06:22:00 -0700 (PDT) schrieb Akash Maheshwari:

Insted of #DIV/0! I would like to display 0. Pls help.

try:
=IFERROR(AVERAGEIF(Sheet1!A1:C100,Summary!C4,Sheet 1!N1:N100),0)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote