Hi all

Bit long - but I am trying to be very clear. Any help is very much appreciated!

I have been helping my friend put together a spreadsheet. She needs to keep track of expenditure on several different sets.

I have one worksheet, 'Books' into which she enters data (including set name/set number + the purchase order number linking that particular entry to a paper record of purchase...)

Another worksheet, entitled 'Summary' keeps track of the amount spent for each set. this worksheet has the following columns - Set Name, Set Number, Projected Total Expenditure, Actual Total Expenditure, Balance, and 'Completed?' (into which she writes 'Yes' when that set is finished with)...

At the moment the 'Actual Total Expenditure' column in the Summary sheet compares both the Set Name and the Set Number entered in the 'Books' page, with those in the 'Summary' page. If both are identical it adds the amount from that particular entry in the Books page to the 'Actual Total Expenditure' column for that Set Name/Number in the 'Summary' page.

She sometimes enters purchases into her Books spreadsheet before she purchases them to help her plan her next few days work.

In one cell in the 'Summary' page I need a warning to appear if she has entered 'Yes' in the Completed column on her Summary page for a set (say Set #1), but there is an entry relating to that set in the Books worksheet without a related Purchase Order #.

The 'Completed?' column is in Summary>column F
The 'Purchase Order Number' column is in Books>column I
In Books>column G is the 'Price' of each entry

In Summary> cell E2 I have this formula:
=IF(E3>0,"PO No's not entered in Books for completed sets to this amount >>"," ")

In Summary> cell E3 I have this:
{=SUM(IF(((Summary!$F$7:$F$65)=("Yes"))*((Books!$I$4:$I$2450)>(1)),(Books!$G$4:$G$2450)," "))}

The problem is with E3 - I want a formula that looks at the 'Competed?' column in the summary sheet, and the Purchase Order Number column in the Books sheet (as well as the Set Name/Number columns of both sheets...)
If "Yes" is entered in the Summary>'Completed?' column of any particular set, but there are entries on the Books page for that set with no related Purchase Order Number entered, I want the total amount of that/those entry/entries to appear in cell E3...

Hopefully this makes sense - as I said before, any help is very much appreciated...

Cheers
Ron