SOLVED

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!

 

data.png

1 Reply
best response confirmed by j10999 (Occasional Contributor)
Solution

@j10999 

=SUMPRODUCT(($E$4:$E$14=A4)*($F$4:$F$14="debit")*($H$4:$H$14="completed")*($I$4:$I$14="False")*$G$4:$G$14)

Maybe with this formula. An alternative could be SUMIFS.