To fetch Count of similar data

Closed
Sri - Aug 17, 2009 at 06:53 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 18, 2009 at 07:24 AM
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 response

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