| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Conditions
I'm trying to add the values in SHEET B column C2:C100 but only if they meet
two criterias. I want my answer in SHEET A colum h. In order to get a result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b column a2:a100 has to equal SHEET A column a1, a2, a3.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions
Do you mean
=SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B'!a2:a100='SHEET A'!A1),'SHEET B'!C2:C100) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Looney" wrote in message ... I'm trying to add the values in SHEET B column C2:C100 but only if they meet two criterias. I want my answer in SHEET A colum h. In order to get a result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b column a2:a100 has to equal SHEET A column a1, a2, a3.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions
Thanks for the response Bob. Yes, that's exactly what I mean. I have tried
that formula but all I get is zeros. "Bob Phillips" wrote: Do you mean =SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B'!a2:a100='SHEET A'!A1),'SHEET B'!C2:C100) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Looney" wrote in message ... I'm trying to add the values in SHEET B column C2:C100 but only if they meet two criterias. I want my answer in SHEET A colum h. In order to get a result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b column a2:a100 has to equal SHEET A column a1, a2, a3.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions
Post some data examples.
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Looney" wrote in message ... Thanks for the response Bob. Yes, that's exactly what I mean. I have tried that formula but all I get is zeros. "Bob Phillips" wrote: Do you mean =SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B'!a2:a100='SHEET A'!A1),'SHEET B'!C2:C100) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Looney" wrote in message ... I'm trying to add the values in SHEET B column C2:C100 but only if they meet two criterias. I want my answer in SHEET A colum h. In order to get a result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b column a2:a100 has to equal SHEET A column a1, a2, a3.... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions
The formula works great Bob. I found out that excel was reading one of the
column as text and the other as number. Once again, thanks for all your help Bob. "Bob Phillips" wrote: Post some data examples. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Looney" wrote in message ... Thanks for the response Bob. Yes, that's exactly what I mean. I have tried that formula but all I get is zeros. "Bob Phillips" wrote: Do you mean =SUMPRODUCT(--('SHEET B'!b2:b100="Other Funds"),--('SHEET B'!a2:a100='SHEET A'!A1),'SHEET B'!C2:C100) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Looney" wrote in message ... I'm trying to add the values in SHEET B column C2:C100 but only if they meet two criterias. I want my answer in SHEET A colum h. In order to get a result, SHEET B column b2:b100 has to equal "Other Funds" and SHEET b column a2:a100 has to equal SHEET A column a1, a2, a3.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple conditions and multiple return values | Excel Worksheet Functions | |||
| COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
| Vlookup with multiple conditions | Excel Worksheet Functions | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Linear Mode
