CALCULATING CELLS AS A TOTAL

  • Thread starter Thread starter EDDIE
  • Start date Start date
E

EDDIE

Help please.

Advice on how to add a row of cells (e.g. a1 - a5) as a
corporate sum (shown in A6) where each cell is shown in
the cell by a letter of the alphabet representing a sum
figure.

i.e

A + B + C + D + E = 15

(where a=5; b=4; c=3; d=2 and e=1)

Thanking you.
 
Hi Jason
just a picky one :-)
no need for a double minus in this case :-)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel calculation problem 2
Variable reference to add cells 4
How to use cell reference? 9
Sum 7
Moving Formulas when Sorting 2
Summing based on a range of criteria 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Dynamic Sum Array Formula Input Help 3

Back
Top