To fetch Count of similar data

Closed
Sri - 17 Aug 2009 à 06:53
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 18 Aug 2009 à 07:24
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 11 April 2009 Status Member Last seen 21 June 2011 307
18 Aug 2009 à 07:24
try this =sum((A:A="Accepted")*(B:B="VB"))
Enter this formula by pressing CTRL + SHIFT+ENTER