Counting data

[Joey]

Hi all

I would like to count data relating to different columns but also i
this data matches certain cells.

A1 to A10 = Areas
B1 to B10 = names

D1 = Area
D2 = Name

The formula should count the names only if they relate to the area an
name data in column D.


Many thanks
Joe

 

[Jason Morin]

=SUMPRODUCT((A1:A10=D1)*(B1:B10=D2))

HTH
Jason
Atlanta, GA

 

[Andy B]

Hi

Try something like:
=SUMPRODUCT((A1:A10=D1)*(B1:B10=D2))

 

[Soo Cheon Jheong]

Hi


=SUMPRODUCT(--(A1:A10&B1:B10=D1&D2))


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--