Subtotal Forum Returning Zero Even Though the Formula Result States a $2,8792,942 result

[Eb0la11]

I have a subtotal formula displaying 0 as the result when I subtotal a column below it even though the Formula Result in the function Argument Dialogue Box states the result to be $2,8792,942.

My cell is formatted to accounting and I am using the exact same function and cell format in cell next to it looking at the column below it with it working.

Formula is this:

=SUBTOTAL(9,P$7:P$1000)

Any idea why?

 

[Eb0la11]

Nevermind I figured it out. Some colleague put a circular reference formula in one of the cells below that was jacking it up...