Hi!

Try this:

=SUMPRODUCT(--(Sheet2!A$2:A$10=901),--(Sheet2!B$2:B$10=1001))

Biff

"tammy" wrote in message
...
Hi I am new to excel and am trying to learn how to count line values from
another worksheet

Worksheet one
PO No Invoice No Line per order
901 1001 3
902 1002 0
903 1003 0

Worksheet two
Po No Inv no part no
901 1001 33mo333
901 1001 44mo444
901 1001 55mo555