Remember Me?

#1
November 6th 06, 07:03 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,670
How to skip the blank cells for calculating StdDev?

Does anyone know how to skip the blank cells for calculating StdDev?
such as, there are a set of data in each cell under colume A, the number of
row will keep changing, but the maximum row of data is 600, so I input the
formula in as following
A601 cell =StdDev(A1:A600,count(A1:A600),0), if the number of data is 600,
then it will be corrected, but if the number of data is 60 only, then the
result is 0.
However, if I change the code as following StdDev(A1:A60,count(A1:A60),0),
then I receive 81 as the result. Does StdDev count the blank cell as a 0
value for following coding StdDev(A1:A600,count(A1:A600),0)? so the result is
0.

#2
November 6th 06, 07:22 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221
How to skip the blank cells for calculating StdDev?

Since empty cells are ignored by STDEV (re Excel Help),
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Does anyone know how to skip the blank cells for calculating StdDev?
such as, there are a set of data in each cell under colume A, the number of
row will keep changing, but the maximum row of data is 600, so I input the
formula in as following
A601 cell =StdDev(A1:A600,count(A1:A600),0), if the number of data is 600,
then it will be corrected, but if the number of data is 60 only, then the
result is 0.
However, if I change the code as following StdDev(A1:A60,count(A1:A60),0),
then I receive 81 as the result. Does StdDev count the blank cell as a 0
value for following coding StdDev(A1:A600,count(A1:A600),0)? so the result is
0.
Does anyone know how to solve this issue? the number of data is not fixed
and I need to calculate StdDev for this variable size of data.
Eric

#3
November 6th 06, 08:28 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 418
How to skip the blank cells for calculating StdDev?

"Eric" wrote apparently:
Does anyone know how to skip the blank cells for calculating StdDev?
[....]
I input the formula in as following
A601 cell =StdDev(A1:A600,count(A1:A600),0)

Since there is no Excel function called StdDev [sic] and since those
are not the correct parameters for the Excel STDEV() function, I
wonder: what exactly are you talking about? Is StdDev() perhaps a UDF
written in VBA?

#4
November 6th 06, 08:38 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221
How to skip the blank cells for calculating StdDev?

wrote
Since there is no Excel function called StdDev [sic] ...

Sorry, my eyes mistook it earlier for STDEV
Pl disregard my response ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post IntricateFool Excel Discussion (Misc queries) 5 June 8th 06 02:45 PM LuLu Excel Worksheet Functions 0 May 9th 06 03:13 PM hlp Charts and Charting in Excel 9 February 24th 06 03:32 PM JackieD Excel Worksheet Functions 14 February 23rd 06 01:57 AM Greg Excel Discussion (Misc queries) 1 March 16th 05 10:23 PM

All times are GMT +1. The time now is 09:11 PM.