Neues Thema starten

An simpler forumula for summng, or averaging dB values in Microsoft Excel or Google Sheets

A familiar challenge is working with dB like from a series of overall values like LAeq or 1/3-octave spectrum is you cannot simple arithmetically sum them or average them.

The classic formula involves converting each cell from dB to Pa, summing the Pascal, and convert back to dB


Both Microsoft Excel and Google Sheets have an easier method, Array Formulas.

In MS Excel the below is equivalent



“This is an array formula, so it must be entered with Ctrl+Shift+Enter.”

In Google Sheets the formula is similia


Besides SUM(), other function like =AVERAGE() can be used on arrays

Anmelden oder Registrieren um einen Kommentar zu veröffentlichen