find and add function between sheets

  • Thread starter Thread starter MLT
  • Start date Start date
M

MLT

=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?
 
Hi

If I understand your request correctly, then on Sheet1
=SUMIF('Per purchase order'!A:A,A8,'Per purchase order'!H:H)
 
Back
Top