List sum IF Status is equal to lookup

Hello,

I am creating a "Stats" table in a dashboard list view. I'd like to do a list Sum for amount - *only if the status is equal to "In Progress"*.

Can someone please advise me on how to do this?

Im not sure how to add conditions in to the expression. or even if this is the correct approach to do so.

Kind Regards,

Luke

+16

Hi,

I have attached a video explaining how to achieve that, I think you can achieve in many ways.

Hope it helps

Regards,

Mus

+1

Can someone please show me?

Sign up