Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to sum numeric values of column (variable length) in 1st available blank cell
Hi, I have an invoice summariser xl document which takes the contents of folder (ie. a quarter) and summaries the invoice contained in. As th quarters can have variable numbers of invoices, I'd like to add function which looks for the ist blank row in a given column (or an column with numeric values if thats easier) and then totals it. should imagine that this would be fairly easy, and a common requiremen but I have been unable to find the appropriate code. If anyone can help me out this would be much apprecciated. Thanks in advance And -- grimji ----------------------------------------------------------------------- grimjim's Profile: http://www.excelforum.com/member.php...fo&userid=1539 View this thread: http://www.excelforum.com/showthread.php?threadid=27009 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum a Column of Variable length | Excel Discussion (Misc queries) | |||
Sum a column of variable length? | Excel Discussion (Misc queries) | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Averaging a variable length column | Excel Programming |