LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 430
Default Looping and inserting negaive totals

How would I code a macro to have it -sum()
Afterwards Col E should total 0.00
In Cell
E426 -754.05
E422 -5,409.85 << I have several groups like this between Row 6 and
427
E420 -13,397.65
E418 -4,132.69
E6 -60.00

I've been trying to alter similar code, but without success.
Thanks in Advance..

Row# Col E
6
7 60.00
.....
418
419 4132.69
420
421 13397.65
422
423 2365.13
424 1522.36
425 1522.36
426
427 754.05

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Totals: Group totals different from Grand totals PsyberFox Excel Discussion (Misc queries) 1 February 13th 08 06:16 PM
Inserting Totals into Worksheet CEverhart Excel Worksheet Functions 1 August 17th 07 12:01 AM
Move the negaive symbol from the right to the left side of a numbe Oldersox Excel Worksheet Functions 2 March 19th 07 03:46 AM
Looping Macro to enter negative totals Jim May Excel Programming 5 July 24th 06 01:27 AM
Comparing/matching totals in a column to totals in a row Nicole L. Excel Worksheet Functions 3 January 27th 05 10:42 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"