If column A status is X then tally column B
Comments
-
Try something like this...
=IF([Column A]@row = "Pay Supplier", SUMIFS([Column B]:[Column B], [Column A]:[Column A], "Pay Supplier"))
Try something like this...
=IF([Column A]@row = "Pay Supplier", SUMIFS([Column B]:[Column B], [Column A]:[Column A], "Pay Supplier"))