using a conditional in STDEV function

R

Researcher

I would like to use the STDEV function on a set of cells that have been
indicated by a conditional statement. I have tried a variety of ways and have
not been able to get it to work using others suggestions. I am wondering if
anyone knows. I have Excel 2007, I am not sure if this has affected my
results. Below is one thing that I tried, that seemed to have worked for
others.

=STDEV(IF((C2:C204)*(P2:p204>0),P2:p204,""))

When looking at the array it returns the value of 15 for every cell that is
in the specified range.
Thanks.
Researcher
 
L

Luke M

Your formula:
=STDEV(IF((C2:C204)*(P2:p204>0),P2:p204))
should work...are you confirming it as an array formula (Ctrl+Shift+Enter)?

This should be taking any number in P2:p204 that is greater than 0 and has a
value other than 0 in the C column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

STDEV in a Formula for Calculated Field in Pivot Table 0
calculate the stdev of an array using text as the criteria 4
Error with stdev array - getting wrong answer 4
find for non zero values in a column Median,Mode,STDEV 3
STDEV function in VB scritp for excel 4
Mail Merge Directory Conditional Page Break 0
Problem with SET & REF function 0
STDEV function on selected values 1

Top