One further thought ..

In Sheet2,

Put in A1:
=IF(Sheet1!B1="","",IF(ISNUMBER(Sheet1!B1),Sheet1! B1-ROW()/10^10,""))

If you actually have a number of source cells in Sheet1's col A with "Total"
(as indicated in your post) where these are of course to be excluded from the
criteria, just replace the formula above (in Sheet2's A1) with:

=IF(Sheet1!B1="","",IF(ISNUMBER(SEARCH("Total",She et1!A1)),"",IF(ISNUMBER(Sheet1!B1),Sheet1!B1-ROW()/10^10,"")))

Then copy down to cover the max expected extent of data in Sheet1's cols A
and B. No change is required to the other formulas. The above will then
return the required results which omits all cells with "Total" in Sheet1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---