| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CALCULATING CELLS AS A TOTAL
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. |
|
#2
|
|||
|
|||
|
Hi
try: =SUMPRODUCT(70-CODE(A1:A5)) -- Regards Frank Kabel Frankfurt, Germany EDDIE wrote: 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. |
|
#3
|
|||
|
|||
|
One way:
=SUMPRODUCT(--(70-CODE(A1:A5))) HTH Jason Atlanta, GA -----Original Message----- 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. . |
|
#4
|
|||
|
|||
|
Hi Jason
just a picky one :-) no need for a double minus in this case :-))) -- Regards Frank Kabel Frankfurt, Germany Jason Morin wrote: One way: =SUMPRODUCT(--(70-CODE(A1:A5))) HTH Jason Atlanta, GA -----Original Message----- 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. . |
|
#5
|
|||
|
|||
|
Yeah, I know. I didn't realize it until I saw your post.
Jason -----Original Message----- Hi Jason just a picky one :-) no need for a double minus in this case :-))) -- Regards Frank Kabel Frankfurt, Germany Jason Morin wrote: One way: =SUMPRODUCT(--(70-CODE(A1:A5))) HTH Jason Atlanta, GA -----Original Message----- 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. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
| Problems calculating total hours | Excel Discussion (Misc queries) | |||
| In SUM cells the # sign keeps showing instead of total | Excel Discussion (Misc queries) | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Linear Mode
