If column A status is X then tally column B

Tammmitha

How do I do this?

If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status.

Thanks

Paul Newcome

Try something like this...

 

=IF([Column A]@row = "Pay Supplier", SUMIFS([Column B]:[Column B], [Column A]:[Column A], "Pay Supplier"))