- Formula
- L_T = 10·log₁₀(Σ 10^(Li/10))
- Output
- dB
- Bands
- Any set of levels
- Standard / Source
- General acoustics (no standard cited)
- Access
- Inline =function
What it does
Combines two or more sound levels on an energy basis — the correct way to add decibels. Because the decibel is logarithmic you cannot just add the numbers: two equal sources are 3 dB louder than one, not twice as loud. =DBADD does this properly, and you type it in any cell like an ordinary spreadsheet function.
How to use it
=DBADD(80, 82, 85)
=DBADD(A1:A3)Pass individual levels, cell references, or a range.
Equation
Worked example
=DBADD(80, 82, 85) → 87.6 dB
The loudest source on its own is 85 dB; adding the 80 and 82 dB contributions raises the total by only ~2.6 dB.
Source
Standard incoherent (energy) decibel summation. No specific published standard is cited in the software.
Related: =DBAVG (energy average of levels) and =DBSUB (energy subtraction, to remove a known component).