Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif
I need to countif 2 diff criteria's are met in diffrent columns for ex:
A B 1. FCC 18/01/2008 2. FID 18/01/2008 3. PTZ 16/01/2008 4. FCC 22/01/2008 If FCC in appears in column A1 and there is a date in B it must count it as 1 in case the answer would be =2 Any ideas ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif
Maybe...
=sumproduct(--(a1:a100="fcc"),--(isnumber(b1:b100)) Adjust the ranges to match--but you can't use whole columns (except in xl2007). =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html Dan wrote: I need to countif 2 diff criteria's are met in diffrent columns for ex: A B 1. FCC 18/01/2008 2. FID 18/01/2008 3. PTZ 16/01/2008 4. FCC 22/01/2008 If FCC in appears in column A1 and there is a date in B it must count it as 1 in case the answer would be =2 Any ideas ? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif
Ps. If you have other numbers in column B, it's more difficult to distinguish
real dates from plain old numbers. Dan wrote: I need to countif 2 diff criteria's are met in diffrent columns for ex: A B 1. FCC 18/01/2008 2. FID 18/01/2008 3. PTZ 16/01/2008 4. FCC 22/01/2008 If FCC in appears in column A1 and there is a date in B it must count it as 1 in case the answer would be =2 Any ideas ? -- Dave Peterson |
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 |