Count Formula

[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

 

[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

 

[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




.

 

[JulieD]

Hi Dave

glad to help

Cheers

Thanks Julied!