=IF(A8='Per purchase order'!A:A,SUM('Per purchase order'!H:H)) statement
"FALSE"
=IF(A10='Per purchase order'!A:A,then,SUM('Per purchase order'!H:H))
statment "640" which is a total of all numbers in column H
=IF(A13='Per purchase order'!A:A,then,('Per purchase order'!H:H))
statment "3" which is the number in H13
=IF(A16='Per purchase order'!A:A,productsum('Per purchase order'!H:H))
statement " FALSE "

As you might see I want to look at column A on sheet 2, search column A on
sheet one for the corresponding text, when found go to column H and add that
number for each time that text is found

I've been working on this for 3 days now, can it be done?

--
I think I am, therfor I am, I think