Help! Here is a sample of data before i explain what i need to do:
EFFEC 22122011 DD 790 790 dd
IBANK PMT 11-040912 1000 1790 11-040912
IBANK PMT STUDY FEES 1000 2790
CASH DEP BRANCH 1250442 500 23880 50442
SBV 124750 3600 27480 sbv
SBV 124751 24 27504 sbv
OK. Text is the description. not too worried about that. first column are the values of the transactions. then it is the running total and lastly the account it has gone to. There is also a blank row between each line. i need to create a total sum and count of all the transactions that have not got any text in the last column i.e. it has not been allocated anywhere. In this case the row with "IBANK PMT STUDY FEES 1000 2790" is what i am looking at. I need to total up 1000 and the fact that it is one transaction in this set of data. here is where it gets sticky. I need to apply this one formula in a separate spreadsheet and have it referenced across multiple sheets and workbooks. help?!
Bookmarks