I have three columns "Billed Date", "Paid Date" and "Amount" and trying to use either SUMIF or SUMIFS function.

I tried using "is null" or "<> null" to sum values and must have the syntax wrong.

If I want to sum on those amounts with "Billed Date" not blank and "Paid Date" blank....

Thanks so much in advance!!