Total of two time keeping codes in one cell

S

something68

Luke M was helping me with the following and I haven’t heard from him so I
may have sent him to the funny farm…he was very close in finding a solution
to my problem. I appreciate it so very much!

Column B, row 8 shows “S†and column C, row 8 shows “SB†and
Column B, row 9 shows “8†and column C, row 9 shows “2â€

How can I have column U, row 8 show the total of “S†and “SB†of “10�
 
S

Stefi

What does total of “S†and “SB†of “10†mean? Please, clarify!
Stefi

„something68†ezt írta:
 
M

Mike H

Hi,

I have looked at answers from Jacob Skaria & Luke M and they seem to have
explored all combinations of what you want in column U. To get you an answer
let us know precisely what you want to appear in column U

Mike
 
D

David Biddulph

If you want U8 to show the total of B9 and C9, in U8 put the formula =B9+C9
 
S

something68

Maybe I'm not explaining what I need very well so I'll try it this way since
I cannot attach an example of an excel sheet:

A B C D E F U

8 SB SF S SB A S
9 8.00 2.00 3.00 8.00 1.00 5.00 24.00

In column A, row 8 I have “SBâ€

In column C, row 8 I have “Sâ€

In column D, row 8 I have “SBâ€

In column F, row 8 I have “Sâ€

In column A, row 9 I have “8â€

In column C, row 9 I have “3â€

In column D, row 9 I have “8â€

In column F, row 9 I have “5â€


I would like Column U to show the total only the “S†and “SB†figures (which
would equal “24.00â€)
 
M

Mike H

Hi,

1 way, try this in col U

=SUMIF(A8:F8,"SB",A9:F9)+SUMIF(A8:F8,"S",A9:F9)

Mike
 
S

something68

That worked and it is so wonderful!!! I am so ecstatic right now I can't sit
still!!!! Thank you, thank you, thank you!
 
M

Mike H

Glad I could help

something68 said:
That worked and it is so wonderful!!! I am so ecstatic right now I can't sit
still!!!! Thank you, thank you, thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top