Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
hi
I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
With formula you cannot..You will have to use a macro .
If this post helps click Yes --------------- Jacob Skaria "Fareez" wrote: hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
Hi,
You could use the SUBTOTAL(109,range) formula. This formula will exclude all rows: 1. which are manually hidden I.e. by Row Hide; or 2. which are concealed as a result of filtering -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Fareez" wrote in message ... hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
With the function subtotal,
example: if your data are in A2:A100 Put into A1 the formula: =SUBTOTAL(109,A2:A100) "Fareez" a écrit dans le message de ... hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
Thanks Ashish. Havent tried the Function_num range 101-111
"Ashish Mathur" wrote: Hi, You could use the SUBTOTAL(109,range) formula. This formula will exclude all rows: 1. which are manually hidden I.e. by Row Hide; or 2. which are concealed as a result of filtering -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Fareez" wrote in message ... hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
The 100 series SUBTOTAL arguments are only available in Excel versions 2003
and later. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Thanks Ashish. Havent tried the Function_num range 101-111 "Ashish Mathur" wrote: Hi, You could use the SUBTOTAL(109,range) formula. This formula will exclude all rows: 1. which are manually hidden I.e. by Row Hide; or 2. which are concealed as a result of filtering -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Fareez" wrote in message ... hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Jacob Skaria" wrote in message ... Thanks Ashish. Havent tried the Function_num range 101-111 "Ashish Mathur" wrote: Hi, You could use the SUBTOTAL(109,range) formula. This formula will exclude all rows: 1. which are manually hidden I.e. by Row Hide; or 2. which are concealed as a result of filtering -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Fareez" wrote in message ... hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
Thanks Biff for the info..
Have worked with CELL() but again the function do no return the height.... If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: The 100 series SUBTOTAL arguments are only available in Excel versions 2003 and later. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Thanks Ashish. Havent tried the Function_num range 101-111 "Ashish Mathur" wrote: Hi, You could use the SUBTOTAL(109,range) formula. This formula will exclude all rows: 1. which are manually hidden I.e. by Row Hide; or 2. which are concealed as a result of filtering -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Fareez" wrote in message ... hi I have hidden some rows, when i sum rows. is there any way to sum only visible rows. that is it shold not sum hidden rows thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|