Something like this?:

=IF(B3="","",SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B) +
SUMIF('Parts Sent to Assembly'!A:A,A3,'Parts Sent to Assembly'!B:B))

Hope this helps.

Pete


On Mar 26, 12:57*am, Richard
wrote:
=IF(B3="","",SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B))
=IF(B3="","",SUMIF('Parts Sent to Assembly'!A:A,A3,'Parts Sent to
Assembly'!B:B))
Can these to formulas be put together somehow?