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
Comments
-
Try something like this...
Β
=IF([Column A]@row = "Pay Supplier", SUMIFS([Column B]:[Column B], [Column A]:[Column A], "Pay Supplier"))