M
MariaLouise Denmark
I have read through all the post about #div/0 error when making a formula
with average, but I cannot seem to get any of them to work?
I've tried entering the array formula, pressing ctrl+ shift+ enter, but it
just comes up with "the formular you have enteret contains an error"
I'm not very experienced in using Excell, but usually I'm pretty good with
stuff like this, so it's so very frustrating! (also I'm Danish, so maybe I'm
missing something in the translation)
Could you step by step tell me what to do?
I've tried this one (among others!)
=AVERAGE(IF(ISERROR(C12:I12)+ISBLANK(C12:I12),"",C12:I12))
BR Maria
with average, but I cannot seem to get any of them to work?
I've tried entering the array formula, pressing ctrl+ shift+ enter, but it
just comes up with "the formular you have enteret contains an error"
I'm not very experienced in using Excell, but usually I'm pretty good with
stuff like this, so it's so very frustrating! (also I'm Danish, so maybe I'm
missing something in the translation)
Could you step by step tell me what to do?
I've tried this one (among others!)
=AVERAGE(IF(ISERROR(C12:I12)+ISBLANK(C12:I12),"",C12:I12))
BR Maria