how do I put 2 separate sums into 1 cell?

Hi all,

I have a listing of numbers in different catagories such as the following:

Type A:
1

Type B:
2


Type C:
4

Total:
7

I want to be able to have a cell automatically calculate to say:
Type A:
"(1/7)"

Type B:
"(2/7)"

Type C:
"(4/7)"

with that exact formating.

Any advise?

A1 = 1
B1 = 2
C1 = 4
D1 = 7 (the formula =SUM(A1:C1)

To have a cell show multiple info, you could try something like:

A2 ="("&A1&"/"&SUM(A1:C1)&")"
or
="("&A1&"/"&D1&")"

Either results in (1/7)

Assuming your original is in A1:A12 and "Type A" is in C1, then in C2:

="("&INDEX($A$1:$A$12,MATCH(C1,$A$1:$A$12,0)+1)&"/"&$A$12&")"

Is that what you need?

copy and paste to other cells as appropriate

I'm sorry, I just realized you might have wanted those quotes to appear as well. If so:

="""("&A1&"/"&SUM(A1:C1)&")"""

or

="""("&A1&"/"&D1&")"""

Nice to know which one worked for you.. we may have all had different understandings of your data layout, etc...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save