Summation of values based on 2 criteria

[Excel_Monkey]

Dear all,


My apologies I am finding this hard to explain, but here we go:

I have a sheet (attached) where I want the column 'I" populated in rows 3 - 43 with the sum of all the 'I' values from rows 50 - 54 have a corresponding 'D' in column G. Each of the rows from 3 - 43 has a code (A0, A50, A100.......) which are to be entered into cells K50 - K54 by the user.

So by way of example, I5 should return 1 instead of 21. It is returning 21 because it is also including the data from I51. This should not be included because cell
G51 contains a w not a d.

please see attached sheet.

many thanks.

[jeffreybrown]

Try SUMIFS

=SUMIFS($I$50:$I$54,$G$50:$G$54,"d",$K$50:$K$54,D5)

[Excel_Monkey]

That does the trick! thanks very much.

[jeffreybrown]

You're welcome. Thanks for the feedback