find and add function between sheets
 

=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

find and add function between sheets
 

Hi

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

--
Regards
Roger Govier

"MLT" wrote in message
...
=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

find and add function between sheets
 

Yes, thank you

** HAVE AN AWESOME DAY **

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


"Roger Govier" wrote:

Hi

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

--
Regards
Roger Govier

"MLT" wrote in message
...
=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