View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
St@cy St@cy is offline
external usenet poster
 
Posts: 24
Default Sumif w/ 2 conditions in in different rows

Never mind. I got it with sumproduct.

"St@cy" wrote:

Please help me to get the following to work properly:
=SUMIF('QA Input'!E9:IV11,AND('QA Input'!E9:IV9=$C$1,'QA
Input'!E11:IV11=$M$1),'QA Input'!E12:IV12)

Basically, I'm trying to add up r12 if r9= a certain integer and r11= a
certain letter.