Q:

Excel Formula with SUMIF

I have to colums, E and F:
E:
'Invoiced Amount'
£150
£600
£300
£375

and F:
'Paid On'
January 2nd
February 3rd

Only invoices that have been paid have a date in column F.  I want to create a formula that basically adds up the totals in column E if there is a date in column F.  How can I do this? I have gotten as far as thinking I might need to use =SUMIF, but I am not sure.
It's been a long time since I have done Excel Formulas.  Please help!

A:

Try this one:
=SUMIF(F2:F10,"<>",E2:E10)

it sums all values in range E2:E10 if corresponding values in range F2:F10 are not empty

