SUMIF with two condition from two ranges
 

I want to sum the cells in D5:D64 where B5:B64="AA", and where E5:E64<"".
So again, I would like it to check for the cells in Column B that = "AA" and
of those check if Column E that < "" and add the cells in column D that meet
both conditions.

SUMIF with two condition from two ranges
 

=sumproduct(--(b5:b64="AA"),--(E5:e64<""),d5:d64)


"JBoyer" wrote:

I want to sum the cells in D5:D64 where B5:B64="AA", and where E5:E64<"".
So again, I would like it to check for the cells in Column B that = "AA" and
of those check if Column E that < "" and add the cells in column D that meet
both conditions.

SUMIF with two condition from two ranges
 

=SUMPRODUCT((B5:B64="AA")*(E5:E64<"")*(D5:D64))


"JBoyer" wrote in message
...
I want to sum the cells in D5:D64 where B5:B64="AA", and where E5:E64<"".
So again, I would like it to check for the cells in Column B that = "AA"
and
of those check if Column E that < "" and add the cells in column D that
meet
both conditions.

SUMIF with two condition from two ranges
 

Thanks, that worked perfect!

"Duke Carey" wrote:

=sumproduct(--(b5:b64="AA"),--(E5:e64<""),d5:d64)


"JBoyer" wrote:

I want to sum the cells in D5:D64 where B5:B64="AA", and where E5:E64<"".
So again, I would like it to check for the cells in Column B that = "AA" and
of those check if Column E that < "" and add the cells in column D that meet
both conditions.