DUKE, YOU ROCK!!!!!!!!!
Thanks a bunch. And I actually think I get how you did it as well.
"Duke Carey" wrote:
Perhaps should have read your question a little more closely
How about
=IF(SUMIF(City,"New York",TotalInv)=0,0,SUMIF(City,"New
York",Sold)/SUMIF(City,"New York",TotalInv))
"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))
|