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
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 18 Aug 2009 à 07:24
Related:
- To fetch Count of similar data
- Excel count occurrences - Guide
- Tmobile data check - Guide
- How to copy data from one excel sheet to another - Guide
- How to hide subscriber count - Guide
- Count names in excel - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
18 Aug 2009 à 07:24
18 Aug 2009 à 07:24
try this =sum((A:A="Accepted")*(B:B="VB"))
Enter this formula by pressing CTRL + SHIFT+ENTER
Enter this formula by pressing CTRL + SHIFT+ENTER