Standard Deviation If in vba macro

[CJK]

Hi all,

I am trying to get the standard deviation of Age when the gender is Male from one worksheet and place it in another worksheet. I have already gotten the average of age for males with the handy dandy averageif worksheetfunction but I cannot seem to get this one working. Please help.

I keep getting:
Run-time error '1004'
Unable to set the FormulaArray property of the Range class

Please Login or Register  to view this content.

I have also tried this and get type mismatch error:

Please Login or Register  to view this content.

I know that in the worksheet itself I can type in stdev(if(....)) and then hit control+shift+enter and it works beautifully, but I need it in a macro.

Thanks!

[Solus Rankin]

Try just

Please Login or Register  to view this content.

[CJK]

I tried that but then I have an issue with the rest of the stuff I have in the IF function.

If I just post a formula into cell I cannot use macro language right? For example, worksheets("Demographics").

I really just want the value placed into the cell like my second code thing is trying to do. But I need to make it an array like control+shift+enter does in order to make it valid, I just don't know how to do that.