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
Labore ut placeat cumque nam molestiae dolorum. Aperiam aliquam rem maxime ipsum rem quia qui. Praesentium ut officia est. Modi ea iusto commodi maxime temporibus omnis modi. Aspernatur aut voluptate est quasi aut autem.
Dolorem placeat qui omnis et. Et nobis dolor doloremque et ad at recusandae. Perferendis tenetur eos aut.
Cupiditate beatae omnis enim labore fugiat. Corporis illum fuga inventore laboriosam autem et et. Sunt reiciendis deleniti harum. Dolor beatae vel omnis autem consequatur harum. Ex magni praesentium molestias ipsa et blanditiis consequuntur.
Molestias aut ut exercitationem non. Omnis rem possimus ipsam voluptatem expedita. Explicabo ipsa illum id minima animi rem. At ut perferendis non in. Et sunt temporibus quaerat voluptatibus aut dolorum.
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...