You can use this excel function to get sum or mean value of a range in your spreadsheet. Just put all your data together (in columns or rows) and use, for example, =AVG_DB(A1:A4) to get the averaged level, or =ADD_DB(B1:B12) to get the non-coherent sum in dB. You just have to download “complemento_db.xla”, and add it to excel. This funciton has been widely used in our group, and no proble appear at all. Nevertheless, you can never know with Microsoft, so UPM and I reject any responsability.

Download