# 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>

What is the formula to add two of the lowests numbers in a group of cells

add a comment

0

=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: **27 times**

Last updated: **Jul 20**

To display two cells contents together in another cell

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]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.