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
Nihil sapiente itaque tenetur esse minima iure. Et non sunt aut id minus modi laudantium. Optio et exercitationem et adipisci.
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...