Error Message #CALC!

Copper Contributor

I am trying to get a list (spilled) under STOCK where my ledger has in column STATUS = "Open".  I am using the formula


but all I get returned is #CALC!    What am I doing wrong?


3 Replies
best response confirmed by allyreckerman (Microsoft)


Perhaps you mean

WOW, that worked. Thank you.

@alcohen43 , you are welcome