Previous Topic Next Topic

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.




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
Dave -
kiran56 -

Hello sir and ma'am my account is "you disagreed with the decision" can't open my account , my account is so important because I have a online class and my account gives our communicate to our classmate and instructor , please help me to recovery God bless and take Care.

2 responses
To protect you, your profile is not visible to people on FB
limbu86 -
HelpiOS -

Hello,

Mohan, your account has been locked
We saw unusual activity on your account. This may mean that someone has used your account without your knowledge.
Account locked January 3, 2022
To protect you, your profile is not visible to people on Facebook and you can't use your account.

Please assist to rectify

1 response
Help! My FB account is not visible anymore
Rusudan -
HelpiOS -

Hello, "your account is not visible to people on Facebook, and you can't use it, If we find you’re old enough, you’ll be able to use Facebook again." Only this message appears when I try to enter fb. I need to restore it ASAP, as my work is 100% dependent on Facebook. Please, help me to prove I'm old enough to be on Fb and to regain access to my profile ASAP

1 response
My Facebook account locked
KD -
HelpiOS -

Hello,

We've seen unusual activity on your account. This may mean that someone has used your account without your knowledge.

Account locked on January 15, 2022
To protect you, your profile is not visible to people on Facebook and you can't use your account.
We'll take you through some steps to unlock your account.

1 response
Aman , your account has been locked We saw unusual activity
Aman -
HelpiOS -

Hello,
Aman, your account has been locked
We saw unusual activity on your account. This may mean that someone has used your account without your knowledge.

Account locked October 20, 2021
To protect you, your profile is not visible to people on Facebook and you can't use your account.
We'll take you through some steps to unlock your account.

1 response