This is an improvement of work from this post.
I have an array formula that is similar to this image. It sums column A when the date in F matches the due date (C).
What I want to do is only sum A when F matches C and B is blank. This way when I add a date into the "Paid On" Column, G and H will no longer reflect that payment as "needed".
This would make my budget sheet much better. Any help appreciated.
Solution: =arrayformula(sumif(C2:C8 & D2:D8 & B2:B8,F2:F11 & G1 & "",A2:A8))