Sumif w/ 2 conditions in in different rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with OFFSET 5
can i avoid repeating rows when adding calculated item in pivot ta 4
Sumifs (I think) 5
Can I have two conditions in a SUMIF? 5
sumif with a second condition 6
Macro problem - not working properly 6
Sumif, having two condition 2
SUMIF with 2 conditions 8

Back
Top