Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif in an ARRAY.
I want to count the number of instances that C2:C487 is equal to G A and
where the numbers in cells E2:E487 are greater than the numbers in cells F2:F487. I |=COUNT(IF(($C$2:$C$487="G A"),$E$2:$E$487, " F2:F487"))}. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif in an ARRAY.
I can read your question more than one way, but I am pretty sure this
formula does what I think you intended to ask for... =SUMPRODUCT(($C$2:$C$487="G A")*($E$2:$E$487F2:F487)) Rick "SW" wrote in message ... I want to count the number of instances that C2:C487 is equal to G A and where the numbers in cells E2:E487 are greater than the numbers in cells F2:F487. I |=COUNT(IF(($C$2:$C$487="G A"),$E$2:$E$487, " F2:F487"))}. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif in an ARRAY.
One way, normal ENTER:
=SUMPRODUCT(($C$2:$C$487="G A")*($E$2:$E$487F2:F487)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "SW" wrote: I want to count the number of instances that C2:C487 is equal to G A and where the numbers in cells E2:E487 are greater than the numbers in cells F2:F487. I |=COUNT(IF(($C$2:$C$487="G A"),$E$2:$E$487, " F2:F487"))}. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array and countif help! | Excel Worksheet Functions | |||
Countif Array | Excel Worksheet Functions | |||
CountIf Array not working | Excel Discussion (Misc queries) | |||
countif within array | Excel Worksheet Functions | |||
sumproduct , array or countif? | Excel Worksheet Functions |