"Error In Value" message??

[Sunshine8790]

I can't share the original data since it contains personal info, so bear with me with the screenshots.
With the help of this board, I was able to successfully create a formula for the July table that worked in pulling the info from the July tab.
I tried to re-create it for August but it's giving me a Value error, even though I changed the columns to be correct for the August tab.
I'm aware that a Pivot table is a good option for something like this, but I prefer this method for visual appeal.

July Tab looks like this:

Total is formulated:

=IF(SUM(D2:R2)=0,"",SUM(D2:R2))

Rank is also formulated:

=IFERROR(RANK(S2,$S$2:S101,0),"")

I literally just duplicated the July tab, and re-named it - and changed and added onto the dates in row 1, so now the total is in column AI, and Rank in AJ - as opposed to S and T in the July column:

This is the formula, that worked, for my July leaderboard:

=TAKE(SORT(FILTER(CHOOSECOLS('July Steps (Practice)'!A2:T10021,20,2,19),'July Steps (Practice)'!A2:A10021="Salary")),A1)

And this is the formula that is giving me the value error for August:

=TAKE(SORT(FILTER(CHOOSECOLS('August Steps'!A2:AJ10022,36,2,35),'August Steps'!A2:A10021="Salary")),A1)

Any help appreciated.

 

[Fluff]

The ranges are not the same number of rows, hence the error.

 

[Sunshine8790]

The ranges are not the same number of rows, hence the error.

Not sure how I overlooked that one. Thank you!

 

[Fluff]

Easily done, unfortunately.

You're welcome & thanks for the feedback.