Hello, I am trying to build a sales leaderboard and I’m almost done with it, but there’s this one part that I cannot figure out with ARRAYFORMULAS.

I’m trying to make it so that whenever a new row is added, a formula is automatically applied to the new row. I don’t want to create 10,000 rows and then drag the formula all the way down 10,000 rows because it displays all weird in the app and it’s not efficient.

I’ve used the ARRAY formula on the ‘Stat Tracker’ sheet within the Google Sheet in the ‘Stat Summary Of The Day’ and it works perfectly there. Whenever I add in a new row, the formula is automatically applied to the new row that was created.

But I am trying to do the same thing in the ‘Email Whitelist’ sheet under the ‘Outreaches (Ref Data)’ column, but it is not working as it should. I’m not sure how to make it so that the formula is applied all the way down through the whole column, even when a new row is created. The formula contains a SUMIF function.

Here is the google sheet: https://docs.google.com/spreadsheets/d/17QsL5KQlPBBNxELy3zM7nIGyHVMEIHOoXlNKyisGvGA/edit?usp=sharing

Here is a screenshot of the formula I’m currently using: http://prntscr.com/ptzq0z

Would anyone be able to help me with this? I’d truly appreciate any guidance or help. This is the final piece to make the leaderboard function perfectly.

I’ll share the leaderboard I’ve created too once it’s complete for anyone that might need it.

Please let me know if I need to clarify anything.