Dear Danial,
For Count of Hidden row, you can use..
*=COUNTA(B1:B7)-SUBTOTAL(103,B1:B7)*
On Mon, Oct 22, 2012 at 7:20 PM, danial mansoor wrote:
> Dear Experts,
>
> kindly provide me countif formula for hidden rows, i triend to use
> subtotal but could fine the way,kindly provide me formula.
>
t;
> to make it more elaborate when i use countif with hidden rows it counts
> everything including hidden and unhidden rows but i want to count only
> UNHIDDEN data not hidden so i need formula for that so kindly provide me
> that formula.
>
>
>
> -------------
but i want to count only UNHIDDEN
data not hidden so i need formula for that so kindly provide me that formula.
Subject: Re: $$Excel-Macros$$ countif in hidden rows
To: excel-macros@googlegroups.com
From: v...@vabs.in
Date: Mon, 22 Oct 2012 14:37:32 +
Hi,
For countif you have to use 102
Hi,
For countif you have to use 102 with subtotal formula.
Rgds//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: danial mansoor
Sender: excel-macros@googlegroups.com
Date: Mon, 22 Oct 2012 13:50:58
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
