LinkBack URL
About LinkBacks
scarpbot 
Not really sure why you are even using SUM, when you want a value for that row only?
Perhaps this will simplify it though...
=sumifS(F$2:F$5,D$2:D$5,H2.E$2:E$5,H$1)
AND wont work like that with a range, you need to compare 1 cell with 1 cell
Not really sure why you are even using SUM, when you want a value for that row only?
Perhaps this will simplify it though...
=sumifS(F$2:F$5,D$2:D$5,H2.E$2:E$5,H$1)
AND wont work like that with a range, you need to compare 1 cell with 1 cell
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
Register To Reply
Bookmarks