MacroRoni

Starter macros › Reports

Quick stats box

Write the total, average, largest and smallest of column B into a small box at H1:I4.

Changes data. A backup copy and an undo point are turned on.

What it does, step by step

  1. Write “Total” in H1
  2. Sum of B2:B1000 into I1
  3. Write “Average” in H2
  4. Average of B2:B1000 into I2
  5. Write “Largest” in H3
  6. Largest of B2:B1000 into I3
  7. Write “Smallest” in H4
  8. Smallest of B2:B1000 into I4
  9. Bold H1:H4
  10. Show I1:I4 as 1,234
  11. Borders around H1:I4

Use it in MacroRoni: open the Starter gallery, search for "Quick stats box", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

More reports macros

ReportsMake a report look professionalDark header row, banded rows, borders, frozen header and fitted columns.Doesn't change valuesReportsPrint-ready reportLandscape on one page wide, header repeated on every page, page numbers in the footer.Doesn't change valuesReportsSave the sheet as a PDFFit the sheet to the page and save it as a PDF next to the workbook.Doesn't change values