Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
What formula can I use to add a column of visible numbers without adding
numbers in the hiden rows? This is what I have tried and it adds the hidden rows =SUM(Production!F16:F81). Thanks, Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Hi Bob,
=Subtotal(9,Production!F16:F81) should do the job ... HTH Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
I cut and pasted the formula and it is still adding all the hidden cells in
that column. Any suggestions. Bob "Carim" wrote: Hi Bob, =Subtotal(9,Production!F16:F81) should do the job ... HTH Carim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Bob,
I thought your hidden rows where the result of a Filter ... In your case, my suggestion would be to use to Insert Name Define all cells in hidden rows and give this range the name Hidden... Then your result will be = sum(wholerange)-sum(hidden) HTH Carim |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Bob,
If you are using XL 2003, you may use : =SUBTOTAL(109,yourRange) Carim |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
I changed the 9 to 109 and it works great.
Thanks for your help. Bob "Carim" wrote: Bob, If you are using XL 2003, you may use : =SUBTOTAL(109,yourRange) Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |