I need to find the small number of the product of two rows, for example
A B C D
Row 1) 2 4 7 8
Row 2) 3 5 9 1
I would like small like this = small((A1*A2,B1*B2,C1*C2,D1*D2),4)
Result should be 6 but instead it is giving me an error.
The idea is that i dont want to create a separate line with the products
Bookmarks