ExcelBanter - Help with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/181285-help-formula.html)

Richard

Help with formula

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

Pete_UK

Help with formula

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?

All times are GMT +1. The time now is 10:18 PM.