STDevIF

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I have a table of hourly data for an entire year. I have a field whic
states the month that each hour is in. I want to calculate th
Standard Deviation of each months data. January = X February = Y etc

However I would like to build a dynamic formula that acts like a SUMI
but actually calculates the STDev based on the month chosen. Doe
anyone know how to do this?

Thank-you
 
Use an array formula (enter with Ctrl-Shift-Enter)
=STDEV(IF(conditions,data_range))
If you are using Excel dates, then
=STDEV(IF(MONTH(date_range)=3,data_range))
would give you the standard deviation of your March data.

Jerry
 
If those month names are actually text--not just dates formatted to show the
month:

=STDEV(IF(A1:A30="Jan",B1:B30))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
 
Back
Top