| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Arguments
I am using this formula =COUNTIF(D6:D11,"K9-3")*1995. I want it to only return true and multiply by 1995 if E6:E11 also contains "Local" rather than "Distance". How can I enter the formula so it will check both arguments? -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=520943 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Arguments
Hi!
Try this: =SUMPRODUCT(--(D6:D11="K9-3"),--(E6:E11="Local"))*1995 Biff "dansargeant" wrote in message ... I am using this formula =COUNTIF(D6:D11,"K9-3")*1995. I want it to only return true and multiply by 1995 if E6:E11 also contains "Local" rather than "Distance". How can I enter the formula so it will check both arguments? -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=520943 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Arguments
Hey, Thanks Biff!! It worked great!! DS -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=520943 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple Arguments
You're welcome. Thanks for the feedback!
Biff "dansargeant" wrote in message ... Hey, Thanks Biff!! It worked great!! DS -- dansargeant ------------------------------------------------------------------------ dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852 View this thread: http://www.excelforum.com/showthread...hreadid=520943 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurances of multiple arguments | Excel Discussion (Misc queries) | |||
| how do I count with multiple arguments | Excel Worksheet Functions | |||
| multiple "if" arguments | Excel Discussion (Misc queries) | |||
| Multiple vlookup arguments | Excel Worksheet Functions | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Hybrid Mode
