View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003

I don't suppose this is possible, but...

K12, K13, etc for about 10 rows need to be totals, totals of several
subtotals consisting of (A X B) + (C X D) + (E X F) + ... Do I have
to have a seperate set of cells to calculate each (A X B) + (C X D) +
(E X F) + ... for each K cell or can I somehow link each K cell to a
place where each A, B, C, etc can be input and then get each subtotal,
ie (A X B) + (C X D) + (E X F) + ... for each K cell to appear in each
K cell? (Long sentence - sorry.)