Maybe..
=IF(SUM(IF(City="New York",TotalInv,0)=0,0,SUM(IF(City="New
York",Sold,0))/SUM(IF(City="New York",TotalInv,0)))
"Andy" wrote:
> Like a previous post, trying to avoid the #div/0 error. I tried to get
> something from the previous post, but have no ideas? Any help?
>
> Named Ranges:
> City = B1:B1000
> Sold = Total Number Sold, C1:C1000
> TotalInv = Total Remaining in Stock, D1:D1000
>
> =SUM(IF(City="New York",Sold,0))/SUM(IF(City="New York",TotalInv,0))
Bookmarks