Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif AND countif something else too!
Hi, I'm trying to COUNTIF in one range at the same time as COUNTIF in another, and put the answer in one cell. In English, the formula might be: Count if K1:K900 is 'tim' and J1:J900 is 'clever'. To return how many times tim is clever. (For example. I know that, in fact, Tim is actually quite dim) Thanks Tim -- Tim3057 ------------------------------------------------------------------------ Tim3057's Profile: http://www.excelforum.com/member.php...o&userid=30403 View this thread: http://www.excelforum.com/showthread...hreadid=500730 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif AND countif something else too!
One way:
=SUMPRODUCT(--(K1:K900="tim"),--(J1:J900="clever")) See http://www.mcgimpsey.com/excel/doubleneg.html for a fuller explanation. In article , Tim3057 wrote: Hi, I'm trying to COUNTIF in one range at the same time as COUNTIF in another, and put the answer in one cell. In English, the formula might be: Count if K1:K900 is 'tim' and J1:J900 is 'clever'. To return how many times tim is clever. (For example. I know that, in fact, Tim is actually quite dim) Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |