You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Are there any better solutions for a conditional STDEV statement
=STDEV(IF(CriteriaRange=Criteria,NumberRange,""))
(which works in Excel) that *don't* require replicating data to brute-force the calculation? I have far too many cells for needless duplication.
It's a shame Apple can't write the right function.
Not sure it is a question of Apple writing the "right" function.😀
Numbers does not support some functions that require a range of values to be held in memory, sometimes called "array formulas". This means that sometimes the solution in Numbers is not as compact as in Excel. Usually there are workarounds. If you can give an example of what you are trying to do (ideally including a screenshot) then someone here should be able to help.
SG
If it is just this one formula, you can make a column of the numbers using your IF formula then use STDEV on that column. Excel is basically making that column internally as part of the formula. Numbers doesn't have that ability so you have to do it in a column in a table.
Another possibility is to use SUBTOTAL. It can do STDEV of a column ignoring hidden rows. Use your criteria in a filter to hide the rows you don't want included.
Conditional STDEV like "SUMIF"
