Best way to check if all sumifs are locked (F4 / $)?
Got clipped in a complex month by month build where the sumifs in one line item had not been locked (F4 / $) and pulled slightly incorrect months for the FY overview as a result.
What‘s the best way to check for this when running low on sleep at 5am? It did not pop up in my general „do numbers make sense“ check as it was a tiny line item. Still frustrating.
Row totals match between source and formula.
Nice. smart. This guy checks
Distinctio et culpa omnis dolore. Id facere quidem inventore illo. Reprehenderit ad aut ducimus iure eos. Ipsa nobis rem vel nemo quia saepe architecto.
Cum accusamus aliquid architecto numquam. Ad aut ut qui voluptas ipsum sit. Eligendi quasi optio culpa quo quis in. Rerum exercitationem ea et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...