Two formulas in one cell

  • Thread starter Thread starter something68
  • Start date Start date
S

something68

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
 
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.
 
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.
 
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...?
 
Back
Top