Previous Topic Next Topic

Count visible&non visible rows on filter

Closed
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 27 Jul 2010 à 07:20
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 28 Jul 2010 à 00:58
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
27 Jul 2010 à 07:58
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 7 February 2010 Status Member Last seen 15 April 2012
28 Jul 2010 à 00:58
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

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

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
My Facebook account locked
KD -
HelpiOS -

1 response
My account is not visible to people on Facebook
Dave -
kiran56 -

2 responses
Help! My FB account is not visible anymore
Rusudan -
HelpiOS -

1 response