Search : in
By :

If and stdev

Last answer on Oct 16, 2009 2:31:17 am BST Geoff, on Oct 15, 2009 3:18:25 am BST 
 Report this message to moderators

Hello,

I'm having problems with my 'if' formula with regards to stdev. I created need excel to calculate the standard deviation of certain rows in a column. The rows I would like to have included in the standard deviation calculation are indicated in column C with a "1", and the values in column J. All other rows (that I do not want in the calculation) in column C are blank. All data is in a separate worksheet named Transcription Data. Here is the formula I wrote: =IF('Transcription Data'!c3:c300, ">0", STDEV('Transcription Data'!J3:J300)) However, the formula keeps calculating the standard deviation of the entire J column. What am I doing wrong? I've also tried =STDEV(IF(c3:c300, ">0", J3:J300))

Any suggestions?

Configuration: Mac OS X
Safari 525.28.3

Best answers for « if and stdev » in :
[Myth] aMSN allows you to know if someone has blocked you on WLM Show aMSN allows you to know if someone has blocked you on Windows Live Messenger Myth Reality Explanations Myth aMSN software allows us to know who blocked us on Windows Live Messenger. Reality FALSE Explanations When it was launched,...
How do I know if a website is secure? Show How do I know if a website is secure? Determine if you are on a secured page or not. Some web sites use a secure connection between the web site and your browser. This may be important to you, for instance, if you want to pay...
What to do if a file cannot be deleted Show What to do if a file cannot be deleted How to get rid of the file? Solution 1: Ensure that the file/folder is not in use Solution 2: Run your system on Safe Mode Solution 3: Download or update your Antivirus program Solution 4: Use...
Access Regedit if disabled by Administrator ShowAccess Regedit if disabled by Administrator Issue Solution Note Issue When i run Regedit it displays " Regedit is disabled by the administrator", what to do? Solution THANKS TO DOUG KNOX!!!!!! This gives back access to REGEDIT!...
[Yahoo] Determine if my contacts are online Show[Yahoo] Determine if my contacts are online If you do not see if your contacts are online (if they still appear in gray, as "disconnected"), you may need to adjust proxy settings. In Yahoo Messenger, once connected, go to...
How to determine if a MSN account is disabled ShowHow to determine if a MSN account is disabled If you do not log in to your MSN Hotmail, MSN Messenger or Passport on the Windows Live ID site or via an instant messaging software (MSN, WLM, etc. ...) For more than 30 days will be...
Sharing an Internet connection ShowAdvantages If you have a local area network (two or more computers connected in a network) with one computer connected to the Internet (via a modem, using a cable, etc.), it may be useful to make the connection accessible to the other computers on...
Ask your question Reply

1

 venkat1926, on Oct 16, 2009 2:31:17 am BST

The sample data is as given below from A1 to B9
1 1
2 2
3 3
2
1 4
1 5
2
3 6
4 7

in C1 copy this formla
=IF(A1=1,B1,0)
co[u C1 down
now in any empty cell copy this fomula
=STDEV(IF(C1:C9<>0,C1:C9))
INVOKE THIS FORMULA WITH CONTROL+SHIFT+ENTER

can you modify this experiment with your data?

if so post confirmation

   
Reply to venkat1926
Ask your question Reply
They need your help