I’m trying to add my accounts receivable by using a query; summing only the invoice values (column AT) where the paid date (BG) is blank. Column BI is the payment amount. I’ve tried several formulas and can’t come up with the right one. A few examples of what I’ve tried. Thanks for reading.

=SUMPRODUCT(AT:AT,ISBLANK(BG:BG)) ------ this returns the sum of the whole column. best result so far

=SUMIF(BG:BG,ISBLANK(BG:BG),BI:BI) ------- result is “0”

=DSUM(AT:BH,AT:AT,ISBLANK(BG:BG)) ------ Err504