=SUMIF(F3:F160,"",D3:D160)

--
__________________________________
HTH

Bob

<Tony Charlton wrote in message
...
Not sure if this could be of help but I wanted the sum of a column where
another column (Paid Date) was empty to give me an outstanding balance. I
am sure there is a way of doing it in one sumif statement but a simple
subtraction got the job done for me??

=SUM(D3:D160)-SUMIF(F3:F160,"<",D3:D160)