Count Formula

D

Dave

I will like to create a formula that will look in column a
and if the field in column b matches it will give me a
count. so for example if in a1 is blue and b1 is yellow
than give me a count of 1 but they both must match blue
and yellow?

Thanks in advance for you assistance

Dave
 
J

JulieD

Dave

not really sure what you're after but here's two ideas for you

=IF(AND(a1="blue",b1="yellow"),1,0)
or
=SUMPRODUCT(((A1:A100)="blue")*((B1:B100)="yellow"))


Cheers
JulieD
 
D

Dave

Thanks Julied!


-----Original Message-----
Dave

not really sure what you're after but here's two ideas for you

=IF(AND(a1="blue",b1="yellow"),1,0)
or
=SUMPRODUCT(((A1:A100)="blue")*((B1:B100)="yellow"))


Cheers
JulieD




.
Click to expand...
 
Top