Formula help

Occasional Contributor

Hi all, I need some guidance on how to complete the "Total completed debit payments" column in Table1 shown below. I'm trying to sum of the debit payments from table 2 by company id where the type = debit, status = completed, and pending = FALSE.

Any help on what some possible formulas would work would be really appreciated!



1 Reply
best response confirmed by j10999 (Occasional Contributor)



Maybe with this formula. An alternative could be SUMIFS.