STDEV With 3 Criteria

[DHAMMOND]

Hello,

I have an STDEV array that calculates with 2 criteria, but It won't calculate with three. How can I get this to work?


Works
=STDEV(IF(Amazon!$M$2:$M$54330>=Summary!D6-52,IF(Amazon!$M$2:$M$54330<=Summary!D6-7,Amazon!$I$2:$I$54330)))

=STDEV(IF([All Dates]>=[Start Date],IF([All Dates]<=[End Date],[Sales])))



Errors
=STDEV(IF(Amazon!$M$2:$M$54330>=Summary!D6-52,IF(Amazon!$M$2:$M$54330<=Summary!D6-7,IF(Amazon!$E$2:$E$54330=F28,Amazon!$I$2:$I$54330))))

=STDEV(IF([All Dates]>=[Start Date],IF([All Dates]<=[End Date],[Brand],[Sales]))))

 

[samdthompson]

Bit hard to tell without the exact nature of the columns, but try:

{=STDEV(
IF(Amazon!$E$2:$E$54330=F28,Amazon!$I$2:$I$54330
IF(Amazon!$M$2:$M$54330>=Summary!D6-52,
IF(Amazon!$M$2:$M$54330<=Summary!D6-7,
))))}

I think its just a case of putting the third argument 1st.

Hope it works, I have constant probs with the STDEV formula.

Cheers,

Sam

 

[Aladin Akyurek]

Assuming that the formula is entered in the Summary sheet...

=STDEV(IF(Amazon!$M$2:$M$54330>=D6-52,IF(Amazon!$M$2:$M$54330<=D6-7,IF(Amazon!$E$2:$E$54330=F28,Amazon!$I$2:$I$54330))))

succeeds to return a numeric value. What is the error you get?

 

[DHAMMOND]

Yes, sorry, the formula is in the Summary sheet. There error is #N/A

 

[DHAMMOND]

Aladin, your post made me ponder the formatting of Amazon!$E$2:$E$54330.

Like a noob, i did not have it formatted as text. It was formatted as general. I didn't know it would make a difference in this case, but it does.

Cheers guys. Thank you both

 

[Aladin Akyurek]

@ DHAMMOND

You are welcome. Thanks for the update.