Formula guidance
Hi guys!
I am trying to help fix a sheet that was built by someone else, and that person is no longer working for the company. They have a Dashboard that pulls data from a metrics sheet, that pulls data from a main data sheet. It looks to me like the sheet was moved or something, as it appears to have disconnected from the formula. I'm trying to redo the formula now, but I'm having a hard time understanding the end of his formula. I've copied it below  does anyone know what the $120 might mean?
The data this is pulling over is a total # of loans, per each individual Loan Officer, on a monthly basis.
=COUNTIFS({RefLO}, Names@row, {Month}, [Oct 2023]$120)
Thanks in advance!!
Answers

120 is the row number. So the count is including rows where the value in the Month range on the other sheet matches the value in column Oct 2023, row 120.
The $ symbol is used to fix the row number, so if you drag this formula to another row it still refers to row 120. Without the $, if you dragged this from row 1 to row 2, for example, the reference would change from row 120 to row 121.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!