Ulet kullanım kılavuzu

{platform} için Ulet’i kullanmaya başlayın.

Total a Range With SUM in Ulet on Mac

A SUM formula keeps a total tied to its inputs. You can check the formula by changing one quantity and watching the total.

Enter a total below the quantities

  1. Open the workbook and put three quantities in B2:B4. The sample uses 12, 6, and 20.

  2. Select B5 and enter =SUM(B2:B4). Press Return.

  3. Check that the total is 38.

The sample quantities with B5 ready for the total.

The sample quantities with B5 ready for the total.

Test a change and save

Change B2 from 12 to 13. B5 should now show 39. Save the XLSX and check that B5 still contains the formula.

The total after B2 changes to 13.

The total after B2 changes to 13.

Related guide open and save an XLSX workbook.

Steps checked in the Mac desktop editor with a practice file, including saving and reopening. Screenshots show the Ulet editor; the test used an isolated profile and file-picker fixtures.

Ulet

Günlük işleriniz için hepsi bir arada ofis paketi.

Özellikleri görüntüle