Blank date field

[Stephrawlings22]

I need to have a total shown of a row if a certain date field is blank, I put in a date if a company has paid their bill.
I am setting up a new page so i can easily see who still owes money
so if in june 2013 sheet they have not got a date to show they have paid the bills i need my new sheet to show the total of the outstanding bills in that month.
Please help

[boopathiraja]

try with isblank() formula elso pl post a sample file

[Stephrawlings22]

Jaguar £895.83 £179.16 £1,074.99 15.02.14
Knowles £120.83 28.02.14
MHA
RSK £68.18 £13.63 £81.81 20.03.14
Old cov £270.00 £54.00 £324.00 14.02.14
Pony Club £20.00 £4.00 £24.00 13.02.14
Tuffnells £175.00 £35.00 £210.00 13.03.14
Cyrenians £625.00 £125.00 £750.00 14.02.14
Rowen Ho £40.00 £8.00 £48.00 09.04.14
Ryder £25.00
Russells
Ralph co £250.00 £50.00 £300.00 04.03.14
St Crispin £302.94 £60.58 £363.52 14.02.14
Tile hill £154.16 £30.84 £185.00 07.03.14
TCI £115.00 £23.00 £138.00 03.03.14
Willowbr £120.00 £24.00 £144.00 14.02.14
Willows £68.33 28.02.14


AS you can see Ryder has not paid as i dont have a date in but using the ISBLANK just shows me a true or false but i would need it to show 25.00
is this possible?

[boopathiraja]

Please attach the file,

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

[Stephrawlings22]

have attached as requested thank you

[Stephrawlings22]

it is the last spreadsheet that shows outstanding that i need to fill in with the details from the corresponding months before.
hope that makes sense

[boopathiraja]

since your date are in column I and the total in column G, the formula would be

=IF(ISBLANK(I2)=TRUE,G2,"")

is this is wat you are looking for ?

[Stephrawlings22]

yes that is great thank you