Prev: printing an excel worksheet
Next: can i insert a pdf file as a comment?to appear only when clicked?
From: something68 on 7 May 2010 15:26
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.
> >
From: something68 on 10 May 2010 10:31
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.
> > >
First  |  Prev  | 
Pages: 1 2
Prev: printing an excel worksheet
Next: can i insert a pdf file as a comment?to appear only when clicked?