What is the formula to add two of the lowests numbers in a group of cells>
What is the formula to add two of the lowests numbers in a group of cells
First time here? Check out the FAQ!
What is the formula to add two of the lowests numbers in a group of cells
=sum(small(b1:b4,1)+(small(b1:b4,2)))
Hi
If the number of cells to be added increases it may become interesting to use:
=SUMPRODUCT(SMALL($A$1:$A$10;ROW(A1:A2)))
Regards
Asked: 2019-07-20 16:18:41 +0100
Seen: 50 times
Last updated: Jul 20 '19
To display two cells contents together in another cell [closed]
Displaying formulas from horizontal block of cells to vertical block of cells [closed]
Calc cells shows only formula and not product/output [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]