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: 5
Default Total up a column as the value change on another

If you don't see the table below properly try Clicking on the
"Original Format" link on the right hand top coner.



I want to write a code to Total up some figures.
Every Change in Date (Column A), Flight No (Column B), Out/In(Column
D),
Column H's figures should total up to "Column I" as it shown in the
example above. Like wise Column J's figures should total up to Column
K.

On Column H there is a formular it values changes automaticaly, but
Column J user enters values. Adding up should be in the same row
because the condition is common to Column I and K.

I hope I made my self clear.

A B D H I J K
Date Flight Out/ Total Total Return Return
No In per per per per
series flight series flight

10.01.05 878 out 6 2
10.01.05 878 out 10 16 3 5
10.01.05 878 in 15 5
10.01.05 878 in 10 4
10.01.05 878 in 10 35 9 18
10.01.05 578 out 15 5
10.01.05 578 out 12 27 3 8
10.01.05 578 in 20 6
10.01.05 578 in 20 40 4 10
11.01.05 878 out 6 2
11.01.05 878 out 10 16 3 5
11.01.05 878 in 10 4
11.01.05 878 in 10 20 9 13
11.01.05 578 out 15 5
11.01.05 578 out 12 27 3 8
11.01.05 578 in 20 6
11.01.05 578 in 20 40 4 10

Thank you very much in advance.
 
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
DIVIDING TOTAL CELLS IN COLUMN BY 16 TRYING TO CHANGE WEIGHT OZ TO HYDROPONICSUSA Excel Worksheet Functions 2 December 11th 06 02:06 PM
VB code to total up a column as the value change on a nother Fernando[_2_] Excel Programming 2 January 24th 05 09:03 PM
VB code to total up a column as the value change on another Fernando[_2_] Excel Programming 0 January 24th 05 07:33 PM
Total up a column on change of another Fernando[_2_] Excel Programming 0 January 23rd 05 04:59 PM
Change Word Total and Grand Total Indu Aronson Excel Programming 2 February 16th 04 07:02 PM


All times are GMT +1. The time now is 04:55 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"