| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to return a result from 2 conditions?
From the information below, I'm need a formula that when
the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3 date count in/ot/dd 6/27/07 10 in 6/30/07 1 dd 7/6/07 9 ot In this example above the correct result would be 10 but I can't get a formula to consider 2 conditions. (Excel 2003) Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return a result from 2 conditions?
Try this:
=SUMPRODUCT(--(A1:A3=DATE(2007,6,27)),--(C1:C3="in"),B1:B3) HTH, Elkar "Christy" wrote: From the information below, I'm need a formula that when the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3 date count in/ot/dd 6/27/07 10 in 6/30/07 1 dd 7/6/07 9 ot In this example above the correct result would be 10 but I can't get a formula to consider 2 conditions. (Excel 2003) Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to return a result from 2 conditions?
It works! Thanks so much.
"Elkar" wrote: Try this: =SUMPRODUCT(--(A1:A3=DATE(2007,6,27)),--(C1:C3="in"),B1:B3) HTH, Elkar "Christy" wrote: From the information below, I'm need a formula that when the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3 date count in/ot/dd 6/27/07 10 in 6/30/07 1 dd 7/6/07 9 ot In this example above the correct result would be 10 but I can't get a formula to consider 2 conditions. (Excel 2003) Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel result return wrong calcuation result | Excel Worksheet Functions | |||
| excel result return wrong calcuation result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| 2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions | |||
| How do I check the conditions of 2 fields to return a result | Excel Discussion (Misc queries) | |||
Linear Mode
