Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I sum only visible data in a column
I have some rows manually hidden, Please is there a formula I can apply to
return the sum of the unhidden data contain in a column? |
#2
|
|||
|
|||
Hi Afolabi,
If you don't want to use VBA (create a UDF), you could review the following pages: http://www.jkp-ads.com/Articles/ExcelNames08.htm http://www.jkp-ads.com/Articles/ExcelNames09.htm In any case, there is a fundamental issue with both approaches: since hiding/unhiding rows doesn't trigger any event, such event will have to be forced from time to time, or maybe you can leave with the formulae updating their result in the next recalculation of the sheet. Regards, KL "Afolabi" wrote in message ... I have some rows manually hidden, Please is there a formula I can apply to return the sum of the unhidden data contain in a column? |
#3
|
|||
|
|||
Depending upon your needs, there is a Copy of visible only cells, click Edit, Go To, select Visible Cells, then select the range and paste. This new range can then be totalled. Otherwise . . I think it's a little VBA code -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390100 |
#4
|
|||
|
|||
If you're using xl2003, you can use =subtotal(). This worksheet function has
been enhanced to include options to ignore manually hidden rows. =subtotal(109,a2:a22) for instance. Afolabi wrote: I have some rows manually hidden, Please is there a formula I can apply to return the sum of the unhidden data contain in a column? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I strip out some parts of a column of text data? | Excel Discussion (Misc queries) | |||
Column charts with multiple data in each column | Charts and Charting in Excel | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions |