Count visible&non visible rows on filter
Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Jul 27, 2010 at 07:20 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jul 28, 2010 at 12:58 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jul 28, 2010 at 12:58 AM
Related:
- Count visible&non visible rows on filter
- Make passwords visible - Guide
- To protect you, your profile is not visible to people on facebook and you can't use your account. - Facebook Forum
- Your account is not visible to people on facebook, and you can't use it. - Facebook Forum
- I think my Facebook account was hacked or someone is using ✓ - Facebook Forum
- Count if cell contains number - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 27, 2010 at 07:58 AM
Jul 27, 2010 at 07:58 AM
Simple count and sumif should give you all count, I would think. And you can use the difference to find out what rows are hidden since you already have count and sum for rows that are visible
Jul 28, 2010 at 12:58 AM
=SUM(IF(C2:C200="Car")*(E2:E200="Incident"),M2:M200)) and CTRL+ALT+ENTER