Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If & Array
What would my formula look like if I had 2 conditions that needed to be met
and then for any that met that condition to count those instances, in this case it is all text entries. Thanks Bec |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If & Array
What are the conditions?
=SUMPRODUCT(--(ISTEXT(Range1)),--(Range2=1),--(Range3=2)) as an example but you need to be more specific -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Bec" wrote in message ... What would my formula look like if I had 2 conditions that needed to be met and then for any that met that condition to count those instances, in this case it is all text entries. Thanks Bec |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If & Array
Do you mean something like this:
...........A..........B 1........D..........B 2........X..........Y 3........X..........C 4........C..........X 5........X..........Y Count instances where column A = X and the same row in column B = Y ? =SUMPRODUCT(--(A1:A5="X"),--(B1:B5="Y")) The result is 2. A better way to do this is to use cells to hold the criteria: D1 = X E1 = Y =SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1)) -- Biff Microsoft Excel MVP "Bec" wrote in message ... What would my formula look like if I had 2 conditions that needed to be met and then for any that met that condition to count those instances, in this case it is all text entries. Thanks Bec |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If & Array
It worked a treat on my test page but I'm having trouble with the 'real'
spreadsheet, maybe because I'm using validation lists? I'll keep going, but thanks so much for the help!! "T. Valko" wrote: Do you mean something like this: ...........A..........B 1........D..........B 2........X..........Y 3........X..........C 4........C..........X 5........X..........Y Count instances where column A = X and the same row in column B = Y ? =SUMPRODUCT(--(A1:A5="X"),--(B1:B5="Y")) The result is 2. A better way to do this is to use cells to hold the criteria: D1 = X E1 = Y =SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1)) -- Biff Microsoft Excel MVP "Bec" wrote in message ... What would my formula look like if I had 2 conditions that needed to be met and then for any that met that condition to count those instances, in this case it is all text entries. Thanks Bec |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If & Array
Try explaining what you're wanting to do in more specific detail. Your
original post was really vague and I was just guessing at what you wanted. -- Biff Microsoft Excel MVP "Bec" wrote in message ... It worked a treat on my test page but I'm having trouble with the 'real' spreadsheet, maybe because I'm using validation lists? I'll keep going, but thanks so much for the help!! "T. Valko" wrote: Do you mean something like this: ...........A..........B 1........D..........B 2........X..........Y 3........X..........C 4........C..........X 5........X..........Y Count instances where column A = X and the same row in column B = Y ? =SUMPRODUCT(--(A1:A5="X"),--(B1:B5="Y")) The result is 2. A better way to do this is to use cells to hold the criteria: D1 = X E1 = Y =SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1)) -- Biff Microsoft Excel MVP "Bec" wrote in message ... What would my formula look like if I had 2 conditions that needed to be met and then for any that met that condition to count those instances, in this case it is all text entries. Thanks Bec |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manipulate an 2D Array into a Column Array? | Excel Discussion (Misc queries) | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Goal Seek On Members of an Array within Array | Excel Worksheet Functions |