mvnForum Homepage


Print at Jun 6, 2020 2:41:15 PM

Posted by Spelunk at Mar 5, 2006 9:44:15 PM
Re: The Shop Tool
A minor error in at least the Apothecary Networth area:

P68: Finished Goods
=SUMPRODUCT(AI11:AI14,AK11:AK14)+SUMPRODUCT(AI16:AI45,AK16:AK45)+SUMPRODUCT(AI25:AI42,AK25:AK42)

Should be
=SUMPRODUCT(AI11:AI14,AK11:AK14)+SUMPRODUCT(AI16:AI23,AK16:AK23)+SUMPRODUCT(AI25:AI42,AK25:AK42)+SUMPRODUCT(AI44:AI45,AK44:AK45)

(Double counting some items).

Puzzle Pirates™ © 2001-2016 Grey Havens, LLC All Rights Reserved.   Terms · Privacy · Affiliates