Sum Values in One Range Based on Criteria in Another
I have the following Excel document, which tracks hours needed to implement various tasks by the development language (c#, sql, vb6):
In the cell E8, I'd like to calculate the total amount of hours for C# work. E9 for SQL and E10 for VB6. Obviously, I can't use the
SUM function. Is it possible to do what I want without eyeballing the spreadsheet and without using macros?