Iterative For loop? SUMIFS?

camkoo

Hi all, I am a little stuck on capturing data without adding additional columns/helper sheet. I need to compare the 2 entries of inventory audit in the same column one by one. To do that I can think of using an iterative For loop. With the example attached below:

• Is it possible to iterate each row, [audit#]1 - [audit#]2... [audit#]2 - [audit#]3...?
• Is it possible to have variables? like a counter/Accumulator?
• If API is needed, any recommendations?

May I please know how I can achieve my goal, which is to obtain Storage A's consumption amount?

Thanks!

SoS | Dan Palenchar

You could do this with a series of IF() statements that evaluate your criteria and output based on the result with the operators you need

camkoo

how about the scalability with using If statements, we are expecting audit numbers to go to 1000+?