software

I want to perform an sumproduct type of function with on column of data (1 x
n) and the minimum value in each row of a 2 x n matrix. Is there a simple
formula that will allow me to do this. I know that I could create a new
column with the minimums or that I could brute force the math, I am just
hoping for something simple since I have to apply it a few hundred times.

Thanks

Hi,

If the (1 x n) range data are in Column A, and the (2 x n) matrix data are
in Columns B and C, use the following formula:
=SUMPRODUCT(A1:A100,IF(B1:B100lt;C1:C100,B1:B100,C1: C100)) and confirm with
CTRL-SHIFT-ENTER.

Regards,
B. R. Ramachandran

quot;ZipCursquot; wrote:

gt; I want to perform an sumproduct type of function with on column of data (1 x
gt; n) and the minimum value in each row of a 2 x n matrix. Is there a simple
gt; formula that will allow me to do this. I know that I could create a new
gt; column with the minimums or that I could brute force the math, I am just
gt; hoping for something simple since I have to apply it a few hundred times.
gt;
gt; Thanks

Thanks, that did the trick. What if instead of a (2xn) matrix, I have one
(1xn) matrix and one (nx1) matrix that I want to select the minimum from.
This doesn't seem to work with that.

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; If the (1 x n) range data are in Column A, and the (2 x n) matrix data are
gt; in Columns B and C, use the following formula:
gt; =SUMPRODUCT(A1:A100,IF(B1:B100lt;C1:C100,B1:B100,C1: C100)) and confirm with
gt; CTRL-SHIFT-ENTER.
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;ZipCursquot; wrote:
gt;
gt; gt; I want to perform an sumproduct type of function with on column of data (1 x
gt; gt; n) and the minimum value in each row of a 2 x n matrix. Is there a simple
gt; gt; formula that will allow me to do this. I know that I could create a new
gt; gt; column with the minimums or that I could brute force the math, I am just
gt; gt; hoping for something simple since I have to apply it a few hundred times.
gt; gt;
gt; gt; Thanks

quot;ZipCursquot; wrote
gt; .. What if instead of a (2xn) matrix, I have one (1xn) matrix
gt; and one (nx1) matrix that I want to select the minimum from.

Assume the (1xn) is A1:A10, and the (nx1) is B1:Z1
Try in say, B2: =SUMPRODUCT(A1:A10*MIN(B1:Z1))
Normal ENTER will do
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
Hi,

If the first 1xn range is in A1:A100, and the second (i.e., nx1 ) range is
in B1:Z1,

=SUM(A1:A100)*MIN(B1:Z1)

Regards,
B. R. Ramachandran

quot;ZipCursquot; wrote:

gt; Thanks, that did the trick. What if instead of a (2xn) matrix, I have one
gt; (1xn) matrix and one (nx1) matrix that I want to select the minimum from.
gt; This doesn't seem to work with that.
gt;
gt; quot;B. R.Ramachandranquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; If the (1 x n) range data are in Column A, and the (2 x n) matrix data are
gt; gt; in Columns B and C, use the following formula:
gt; gt; =SUMPRODUCT(A1:A100,IF(B1:B100lt;C1:C100,B1:B100,C1: C100)) and confirm with
gt; gt; CTRL-SHIFT-ENTER.
gt; gt;
gt; gt; Regards,
gt; gt; B. R. Ramachandran
gt; gt;
gt; gt; quot;ZipCursquot; wrote:
gt; gt;
gt; gt; gt; I want to perform an sumproduct type of function with on column of data (1 x
gt; gt; gt; n) and the minimum value in each row of a 2 x n matrix. Is there a simple
gt; gt; gt; formula that will allow me to do this. I know that I could create a new
gt; gt; gt; column with the minimums or that I could brute force the math, I am just
gt; gt; gt; hoping for something simple since I have to apply it a few hundred times.
gt; gt; gt;
gt; gt; gt; Thanks