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

Hello,
I want to count all the visible and non visible rows even when data is filtered.
Currently using SUMPRODUCT(($E$2:$E$15="Incident")*SUBTOTAL(3,OFFSET($B$2,ROW($B$2:$B$15)-ROW($B$2),))) but its only looking at filtered data, the SUBTOTAL aparantly look only at filtered data. How do i change it to look at both filtered and not filtered data.

Count visible&non visible rows on filter
Make passwords visible - Guide
Count if cell contains number - Excel Forum
Your account is not visible to people on facebook, and you can't use it. ✓ - Facebook Forum
To protect you, your profile is not visible to people on facebook and you can't use your account. - Facebook Forum
I think my Facebook account was hacked or someone is using ✓ - Facebook Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012
Jul 28, 2010 at 12:58 AM

TX, i decided that it must have 2 conditions and used
=SUM(IF(C2:C200="Car")*(E2:E200="Incident"),M2:M200)) and CTRL+ALT+ENTER

Similar discussions

My account is not visible to people on Facebook

To protect you, your profile is not visible to people on FB

how make my account visible

You disagreed with the decision facebook

Aman , your account has been locked We saw unusual activity

Similar discussions

Subscribe To Our Newsletter!