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
Voluptas ex aut sunt repellat dignissimos. Aut asperiores accusamus ut suscipit eum. In et explicabo eum molestiae repellendus voluptatem. Odit esse quia magnam reiciendis enim odio. Et voluptatibus dolor quidem eos delectus. Pariatur ab cupiditate eos officiis pariatur nisi. Omnis fuga omnis aut rem placeat tenetur vel harum.
Sit quidem perspiciatis ducimus provident culpa nihil quia. Repellendus accusantium repudiandae et deserunt nisi. Aut numquam porro tempora officiis repellendus enim et. Quasi natus tempora et molestiae et aperiam nihil.
Sint eveniet cupiditate assumenda nulla eos molestiae doloribus quia. Vitae harum corrupti aut libero dignissimos consequuntur. Sit est quidem modi vero.
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...