| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you ignore hidden rows in a SUMIF() function? | Excel Worksheet Functions | |||
| sumif 2 text conditions | Excel Worksheet Functions | |||
| SumIF full columns, multiple conditions | Excel Discussion (Misc queries) | |||
| How do I do a sumif function not including hidden rows? | Excel Worksheet Functions | |||
| Sumif with 2 conditions | Excel Discussion (Misc queries) | |||
Linear Mode
