market-farming AT lists.ibiblio.org
Subject: Market Farming
List archive
- From: "Beth Spaugh" <lists AT rhomestead.com>
- To: "'Market Farming'" <market-farming AT lists.ibiblio.org>
- Subject: Re: [Market-farming] spreadsheet question
- Date: Tue, 11 Feb 2014 11:39:28 -0500
Thanks all for the help on using
SUMPRODUCT. First time, I assumed the format was c2:d2, c62,d62 which did not
work. C2:c62, d2:d62 works. Beth Spaugh http://rhomestead.com
http://www.facebook.com/rhomestead "How we eat determines, to a considerable extent, how the world
is used." - Wendell Berry "Without power over our food, any notion of democracy is
empty." - Frances Moore Lappe It's not that nice guys finish last. They have a whole different
notion where the finish line is. - unknown From:
market-farming-bounces AT lists.ibiblio.org
[mailto:market-farming-bounces AT lists.ibiblio.org] On Behalf Of Maryellen Sheehan Hi Beth, (Thank you all for such great information on this list--I don't often
chime in, but I appreciate being a part of the list!) I think that the SUMPRODUCT formula is best for what you want to do.
I haven't done this with more than 2 arrays, but it's really helpful for
calculating value. It should work if you set it up like: =SUMPRODUCT(array 1,array 2) where array 1 should be the first column of numbers and array 2 the
second column of numbers (So array 1 might be the column of the values of each item and array 2
the column of the quantity of each item) The arrays need to be set up in this format... C2:C63, with the
first cell in the column, then a colon, then the last cell in the column. So =SUMPRODUCT(C2:C63,D2:D63) multiplies all the items between C2 and C63 together with their
corresponding values in D2 through D63, and then adds the products all up for a
total. The only really important thing is that you have to have
identically sized arrays or it won't work. If this still doesn't work, it may be that there are other formulas
embedded in the spreadsheet? Let me know if you are still getting error
messages and I can dig out my version of that sheet and see if there is
something else weird in it. Good luck, Maryellen
|
-
Re: [Market-farming] spreadsheet question,
Maryellen Sheehan, 02/11/2014
- Re: [Market-farming] spreadsheet question, Beth Spaugh, 02/11/2014
Archive powered by MHonArc 2.6.24.