Two formulas in one cell

Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am too
confusing here.

Can you give us a simple example
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme of the data and the expected results?


"something68" wrote in message
...
Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am
too
confusing here.

What is "this" that did not work? You need to provide a complete explanation
of your problem, or keep the conversation in the original thread.

Regards,
Fred

"something68" wrote in message
...
Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am
too
confusing here.

More explanation would be helpful
--
Wag more, bark less


"something68" wrote:

Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am too
confusing here.

If this is the post you are talking about
C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0

As you can see, “A� (shown in columns D and L) and “AL� (shown in columns C
and D) are in two separate columns;

I would like to show their totals in two separate columns, i.e, O (totals of
all “A�) and R (totals of “AL�) in the example above.


My suggestion would be that you have "helper" columns for "C" and "D"

then in column "C" you would have the formula
=TEXT(A3,"0.0")&", "&TEXT(B3,"0.0")
assuming that the "H" information is in A3
and
assuming that the "AL" information is in B3

sticking with your columns assume the "helper" columns for "D" are in "E"
and "F"
then in column "D" you would have the formula
=TEXT(E3,"0.0")&", "&TEXT(F3,"0.0")
assuming that the "A" information is in E3
and
assuming that the "AL" information is in F3

Then in your column "R" your equation could be
=TEXT(A3,"0.0")&", "&TEXT(B3+F3,"0.0")

These helper columns could be hidden if needed.
--
Wag more, bark less


"something68" wrote:

Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am too
confusing here.

Yes, the example below is what I was talking about. I will try it Monday.

I apologize for not getting back to you sooner, but I don't seem to be
notified of replies, even though I've check the box to be notified.

Thank you. I will let you know if this works.


"Brad" wrote:

If this is the post you are talking about
C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0

As you can see, “A� (shown in columns D and L) and “AL� (shown in columns C
and D) are in two separate columns;

I would like to show their totals in two separate columns, i.e, O (totals of
all “A�) and R (totals of “AL�) in the example above.


My suggestion would be that you have "helper" columns for "C" and "D"

then in column "C" you would have the formula
=TEXT(A3,"0.0")&", "&TEXT(B3,"0.0")
assuming that the "H" information is in A3
and
assuming that the "AL" information is in B3

sticking with your columns assume the "helper" columns for "D" are in "E"
and "F"
then in column "D" you would have the formula
=TEXT(E3,"0.0")&", "&TEXT(F3,"0.0")
assuming that the "A" information is in E3
and
assuming that the "AL" information is in F3

Then in your column "R" your equation could be
=TEXT(A3,"0.0")&", "&TEXT(B3+F3,"0.0")

These helper columns could be hidden if needed.
--
Wag more, bark less


"something68" wrote:

Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am too
confusing here.

I'm afraid this latest formula did not work either. I am obviously not
explaining very well what I need. I have a better example of an excel sheet,
but can't figure how to make the columns total the way I need them to without
printing out, totaling and then typing in the totals.

I have Annual AND Personal hours in one column and I also have Annual and
Administrative Leave in another column and would like to show the totals of
Annual hours in one column, at the same time, show total of Personal hours in
a different column and show the total of Administrative Leave hours in, yet,
another column...?

"something68" wrote:

Yes, the example below is what I was talking about. I will try it Monday.

I apologize for not getting back to you sooner, but I don't seem to be
notified of replies, even though I've check the box to be notified.

Thank you. I will let you know if this works.


"Brad" wrote:

If this is the post you are talking about
C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0

As you can see, “A� (shown in columns D and L) and “AL� (shown in columns C
and D) are in two separate columns;

I would like to show their totals in two separate columns, i.e, O (totals of
all “A�) and R (totals of “AL�) in the example above.


My suggestion would be that you have "helper" columns for "C" and "D"

then in column "C" you would have the formula
=TEXT(A3,"0.0")&", "&TEXT(B3,"0.0")
assuming that the "H" information is in A3
and
assuming that the "AL" information is in B3

sticking with your columns assume the "helper" columns for "D" are in "E"
and "F"
then in column "D" you would have the formula
=TEXT(E3,"0.0")&", "&TEXT(F3,"0.0")
assuming that the "A" information is in E3
and
assuming that the "AL" information is in F3

Then in your column "R" your equation could be
=TEXT(A3,"0.0")&", "&TEXT(B3+F3,"0.0")

These helper columns could be hidden if needed.
--
Wag more, bark less


"something68" wrote:

Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am too
confusing here.