# Count entires

#### razaas

##### Member
Any help will be highly appreciate, I want to count the number of entries in column-C of sheet1 if the data in column-A of sheet1match with data of cell A1 of sheet2

Example:

SHEET1

Col-A Col-B Col-C Col-D

B-001 1234 12-May-09 Need formula to get the desired result

B-002 3241 05-Feb-09

B-003 5411 22-Sep-09

B-002 2213 07-Nov-09

B-003 4221 14-Mar-09

SHEET2

Col-A

B-002

Thanks

Razaas

=+COUNTIF(Sheet1!A1:A5,Sheet2!A1)

will count the number of entries in Sheet 1, Column A that match Sheet 2 A1

Change A5 to match your data

Hui, Thanks a lot, it works well but i want to count the entries of columnC (Sheet1) if the data of columnA (Sheet1) match with cell A1 (Sheet2). Your suggested formula is fine too and giving the desired result, but out of curiousity elaborating to see if columnC can be counted.

Thanks,

Razaas

Razaas

The following will do it

=+SUMPRODUCT(1*(Sheet1!\$A\$1:\$A\$5=Sheet2!\$A\$1)*(Sheet1!\$C\$1:\$C\$5&#60;&#62;""))

delete a date in C4 and it will show 1 instead of 2

Thanks a million Hui