Counting data

J

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
 
S

Soo Cheon Jheong

Hi


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


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