Hi all,

I have a question related to calculating the STDEV of daily returns with multiple criteria. The data in the spreadsheet is sorted on firm id and year. I have multiple firms and multiple years in my spread sheet. Which formula should I use to for example calculate the STDEV of Firm XYZ in Year 2006?

I have tried using: =STDEV(IF((firm_id range=firm id)*(year range=year); value range; "")) and used ctrl+shift+enter, but it does not seem to work.

Can anyone help me with this issue?

Thanks a lot in advance!

Kind regards,
Nicole