Hi all,
I have two columns -Students column(Consists of many studenst) and year column(has many years),
I want to find how many times does a student(Girish) has appeared in the year (2000)
pls do eply.
thanks in advance
Hi all,
I have two columns -Students column(Consists of many studenst) and year column(has many years),
I want to find how many times does a student(Girish) has appeared in the year (2000)
pls do eply.
thanks in advance
Hi there,
Have you tried the COUNTIFS formula?
Can you attach the file so we can check it?
Best regards,
Filipe
thanks but countifs is not working.
if there are 2 columns
Col A Col B
a 1999
b 2000
c 2001
a 2000
r ........
f
In this 2 col find how many time 'a' has appeared in the year 2000??
As per pipoliveira suggestion make use of countif function like the below
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Yep, that's the formula alright.
I will account using the two criterias: "A" & "2000".
BR,
Filipe
Yep, that's the formula alright.
I will account using the two criterias: "A" & "2000".
BR,
Filipe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks