View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBoyer JBoyer is offline
external usenet poster
 
Posts: 72
Default 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.