Hi there

I have an issue with a workbook where the maxifs function has stopped working. Usually, it would pick up the latest period in the data and then i have another column to see if the periods in the file are less than or equal to the latest period. This allows me to run pivots based on comparable data. For some reason, this function has stopped working and as you can see in the file, I am getting 0 as a value instead of 11 (Nov 2024 is the latest set of data included).

Any help with this would be greatly appreciated.

test current period.xlsx