Somehow this formula it's not working and i can't figure out why.
=B4-I4-J4-(SUMIFS([Inventory2014.xlsx]Inventory!F:F;[Inventory2014.xlsx]Inventory!A:A;$A4))
B4 it's 10€
I4 it's 0,71€
J4 it's 0,44€
and A4 on SUMIF it's 2,39€.
Shows me a result 8,85€, somehow it's not subtracting A4.
It's supposed to be 6,46€.
I'll post the workbooks on this thread:
Sales2014.xlsxInventory2014.xlsx
Sorry to have to do this, but...
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-form...ofit-calc.html
Note: I did respond on your other thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks