kelvin2088
Board Regular
- Joined
- Mar 11, 2010
- Messages
- 78
I have 2 workbooks, workbook A and workbook B.
Workbook A contains date, product Name and profit associated with that product. look like this:
Date Product Profit
1/1/2010 Apple $1
1/1/2010 Banana $2
1/2/2010 Apple $3
1/3/2010 Apple $4
1/5/2010 Banana $3
Workbook B contains product name and Total profit of each product, like this:
Product Total Profit
Apple $8
Banana $5
I'm just wondering can "sumif" function manage multi-workbook calculation? (I tried, and it returned me error)
If not, is there any alternative to that function /or formula? Thanks!!
Workbook A contains date, product Name and profit associated with that product. look like this:
Date Product Profit
1/1/2010 Apple $1
1/1/2010 Banana $2
1/2/2010 Apple $3
1/3/2010 Apple $4
1/5/2010 Banana $3
Workbook B contains product name and Total profit of each product, like this:
Product Total Profit
Apple $8
Banana $5
I'm just wondering can "sumif" function manage multi-workbook calculation? (I tried, and it returned me error)
If not, is there any alternative to that function /or formula? Thanks!!