Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting a Column when Three Conditions are true
I am having a difficult time finding anyone who can answer this question for
me. A B C D 1 7/17/2006 06.123.456 224 2 7/17/2006 06.123.457 3 7/17/2006 06.123.458 4 7/17/2006 06.123.459 34 5 7/17/2006 06.123.460 6 7/17/2006 06.123.461 7 7/17/2006 06.123.462 32 8 7/17/2006 06.123.463 32 9 7/18/2006 06.123.464 10 7/19/2006 06.123.465 11 7/20/2006 06.123.466 32 12 7/21/2006 06.123.467 13 7/22/2006 06.123.468 Basically I need a formula to do the following: When Column "A" (Date) equals a certain date (i.e.: 7/17/06), then look at corresponding columns in that row where Column "C" (.06.123.456) and Column "D" (224). If they both have a value (TRUE), then it has a value of (1), then sum all the instances where it is true. In the example above, for 7/17/06 the answer would be 4. The closestr thing I got wa the following function: =SUMPRODUCT(--('Service Request Log'!$B$4:$B$5000=$A205)*('Service Request Log'!$C$4:$C$5000<"0"))+SUMPRODUCT(--('Service Request Log'!$B$4:$B$5000=$A205)*('Service Request Log'!$O$4:$O$5000)<0) But it is summing the two columns ( "C" & "D" in the example) together so I get a value of "12". Thanks for any help someone might be able to give me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Add items in column 3 if column 1 and 2 conditions are met | Excel Worksheet Functions |