| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Criterion in a SUMIF function
How would I incorporate 2 criterion into the SUMIF function? For example, in
the following example I have the formula look to the A2:A2000 range for the value referrenced in C2 and sum only those numbers in range B2:B2000 that meet this criteria. That's the easy part. How would I add another layer of criteria to the formula below in addition to that specified by "C2" - say, EXACT(E2,VLOOKUP(E1,A2:B2000,2,FALSE))=TRUE? =SUMIF(B2:B2000,E2,C2:C2000) thx. -- iperlovsky |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple criterion to give sum | Excel Worksheet Functions | |||
| VLOOKUP and DGET to find a value with multiple criterion | Excel Worksheet Functions | |||
| Counting text across multiple sheets with a specific criterion | Excel Worksheet Functions | |||
| Multiple criterion including wildcards to sum in a range | Excel Worksheet Functions | |||
| How do I put more than one criterion in a SUMIF function? | Excel Worksheet Functions | |||
Threaded Mode
