ExcelBanter - Sumif w/ 2 conditions in in different rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumif w/ 2 conditions in in different rows (https://www.excelbanter.com/excel-worksheet-functions/127987-sumif-w-2-conditions-different-rows.html)

St@cy

Sumif w/ 2 conditions in in different rows

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.

St@cy

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.

All times are GMT +1. The time now is 10:46 PM.