Countif

[Dan]

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]

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 here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Dave Peterson]

Ps. If you have other numbers in column B, it's more difficult to distinguish
real dates from plain old numbers.