SUMIF with two condition from two ranges

[JBoyer]

I want to sum the cells in D564 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.

 

[Duke Carey]

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

 

[Gaurav]

=SUMPRODUCT((B5:B64="AA")*(E5:E64<>"")*(D564))

 

[JBoyer]

Thanks, that worked perfect!

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