View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default how do i add up 2 x columns separately and also do a minu

In row 3 enter =sum(a1:a2) in column A

Then copy and paste in column B and column C.
--
Brevity is the soul of wit.


"sierra_louise" wrote:

You are right in what I need.. How do I do this..
Simple terms please im only a beginner using Excel

Thanks GHawkins

"GHawkins" wrote:

Could you explain in a little more detail what you are trying to do? It
sounds like you need:

Column A Column B Column C
Row 1 4 3 A - B = 1
Row 2 8 5 A - B = 3
Row 3 Sum A = 12 Sum B = 8 Sum C = 4

"sierra_louise" wrote:

i want to add column A (require amount at bottom of page and also in Column C
column B (require amount at bottom of page) but these minus the total in
Column C
total Column C (which is A minus B)

How do i do this.. please help