Excel 2007 : Standard Deviation

Could you upload a sample of the workbook?

Take a look at using the DCOUNT function: it allows use of multiple criteria and ideally suited to the task.

A SUMPRODUCT formula is another option.

Hi Palmetto,

I have uploaded the worksheet. Could you please give me the formula? Please note the sample range is 01/01/2005 to 30/06/2009. But, the test is to be done for range 01/07/2009m to 30/08/2009.

Thanks

See attached, which uses the DCOUNT function with criteria.

The criteria are set up on rows 1:2, beginning at P1.
Each of your three conditions requires its own criteria, so there are three sets of criteria.

The data was slightly rearranged to remove the blank rows at the top between the header and data cells.

You can put the DCOUNT formulas whereever you like.

Additional flexibility for passing dates to the criteria cells is created by using two input cells for the date range: cells P5:Q5. Change the dates here to adjust the date range in the criteria cells.

HI Palmettto,

Thanks very much for your help. I had inadverntently forgotten to include one part of the question i.e less than 1 SD.

Could you kindly set this formula for me please ? I tried and failed.

Could you kindly set this formula for me please ? I tried and failed.

It's not really difficult. You should study the formula and function a bit to get an understanding.

I've added the additional count and have colored-coded the criteria cells related to each count so you can easily see which one is used to get the count.

Thank you very much Palmetto.

Glad to have been of help.

If you're satisfied with the solution please mark your thread as solved and be sure to add to the reputation of those who contributed

How To Mark Your Thread As Solved

How To add To A User's Reputation