- Formula
- L_oct = 10·log₁₀(10^(L₁/10) + 10^(L₂/10) + 10^(L₃/10))
- Output
- dB
- Bands
- 1/3-octave in → octave out
- Standard / Source
- General acoustics (no standard cited)
- Access
- Inline =function
What it does
Converts a one-third-octave sound level spectrum to octave bands by energy-summing each group of three adjacent 1/3-octave bands into their parent octave. This is the correct way to coarsen a level spectrum. The 1/3 › 1/1 ribbon menu's Sum→Octave item does this for picked source rows, writing a live =SUMTHIRDOCTAVE formula into each octave band of the selected row.
Equation
For each octave band, over its three 1/3-octave sub-bands:
How to use it
=SUMTHIRDTOOCTAVE(range)— returns the overall energetic sum across the octaves.=SUMTHIRDOCTAVE(range, band)— returns the value for a single octave band.
ℹ️ These functions map cells positionally and assume a full-range reference (27 cells for a 1/3-octave spectrum).
Worked example
Three 1/3-octave bands at 70, 72 and 74 dB combine into one octave:
Source
Standard energy summation. No specific published standard is cited in the software.