To fetch Count of similar data

Closed
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
How can i get a count of same data that presents in one sheet to another sheet based on the conditions.
Ex: in Sheet1 i have two columns like
COL A COLB
Accepted VB
Accepted VB
Assigned Excel
Accepted VB
Reopen Java
Reopen VB
Accepted Java

Result shld be:

COLA(count of Accepted) COLB(count of Reopen) COLC
3 1 VB
1 1 JAVA

Let me know if you want to be more clear

your help will be Appriciated

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
try this =sum((A:A="Accepted")*(B:B="VB"))
Enter this formula by pressing CTRL + SHIFT+ENTER