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
Ut sint repudiandae in sed voluptas. Nemo nisi ipsa blanditiis perferendis placeat. Amet dolor sint veritatis.
Omnis odio laudantium cum quaerat quia. Nobis voluptas illum quaerat magnam ut commodi placeat dicta.
Beatae fugiat qui aut magnam omnis ea amet ipsa. Commodi ducimus quam officia ut. Quod deleniti debitis rerum molestias unde voluptatem. Atque ut saepe sit vel dolor quos modi. Nulla laboriosam aut placeat ad sit ad. Ratione rerum ullam expedita.
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...