**=SUMPRODUCT(MID(G2,{1;2;3},1)*1)** I found this formula in a notebook. Can you understand it’s purpose? I’ll explain it in this post. I’ll also expand it for a more complex case. (more…)

# Auditing

Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. (more…)