LinkBack URL
About LinkBacks
If E3 matches something in column A:A and if F2 matches something in B:B then work out the cost in C:C for the matches
anyone help
If E3 matches something in column A:A and if F2 matches something in B:B then work out the cost in C:C for the matches
anyone help
does SUMIFS work on your version of excel ?
F3 =copy and paste across rest of the table
=SUMIFS($C:$C,$A:$A,$E3,$B:$B,F$2)
I could be wrong here but I don't think 2003 has the Sumifs function
Try array formula
Press control/shift/enter simultaneously to commit=SUM(IF(A2:A17=E3,IF(B2:B17=F2,C2:C17,0),0))
Cheers
Phil
Phil, you are not wrong, sumifS() came out with 2007 (you could use a sumproduct() instead though), however....
m_789 I notice that the file you uploaded indicates 2007 or later (.xlsx), but your profile says 2003. Please update your profile as necessary, members tailor questions based on your excel version
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
=SUM(INDEX(($A$2:$A$17=$E3)*($B$2:$B$17=F$2)*($C$2:$C$17),0))
Try the formula in "F3" and copy towards right and down
Another one.....
In F3
and then drag across and down.=SUMPRODUCT(--($A$2:$A$17=$E3),--($B$2:$B$17=F$2),$C$2:$C$17)
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks