Thread: Sum + IF Array wrong sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ATL_Gabriel ATL_Gabriel is offline
external usenet poster
  
Posts: 3
Default Sum + IF Array wrong sum
=SUM(IF(Prod={"Product_12","Product_100"},Vol,0))
This funtion array fails to return the correct sum. The product name (Prod)
column and value (Vol) column reprsents about 900 rows. The fomula returns
the wrong sum when this happens. If I reduce rows to 258 or less the correct
sum is returned. Is there a limitation when using arrays.
Reply With QuoteReply With Quote