find and add function between sheets

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?
 
R

Roger Govier

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a table for multiple sheets Excel 2007 2
Lookup across multiple columns within multiple sheets 2
find and add vaules 1
need zeros! 3
Subforms 3
need help to update macro to office 2007 macro enabled workbook 1
Calculating sum product between columns. 3
Data Validation and total Sum???? 1

Top