• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count entires

R

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<>""))

delete a date in C4 and it will show 1 instead of 2
 
You must log in or register to reply here.
Back
Top