tlalbritton03
New Member
- Joined
- Oct 1, 2017
- Messages
- 3
I have searched and looked all over the internet and this site but can't figure out how to make this work.
I was given a tracking spreadsheet that I want to automate counts. Each row has the 14 days of the 2 week payperiod beginning in D9 through Q9:
[TABLE="width: 602"]
<tbody>[TR]
[TD="class: xl64, width: 43"]SUN[/TD]
[TD="class: xl64, width: 43"]MON[/TD]
[TD="class: xl64, width: 43"]TUE[/TD]
[TD="class: xl64, width: 43"]WED[/TD]
[TD="class: xl64, width: 43"]THU[/TD]
[TD="class: xl64, width: 43"]FRI[/TD]
[TD="class: xl64, width: 43"]SAT[/TD]
[TD="class: xl64, width: 43"]SUN[/TD]
[TD="class: xl64, width: 43"]MON[/TD]
[TD="class: xl64, width: 43"]TUE[/TD]
[TD="class: xl64, width: 43"]WED[/TD]
[TD="class: xl64, width: 43"]THU[/TD]
[TD="class: xl64, width: 43"]FRI[/TD]
[TD="class: xl64, width: 43"]SAT[/TD]
[/TR]
</tbody>[/TABLE]
Previously entered data would be such as under Monday A-9, Tuesday A-9, Wed S-4, etc. in D10:Q10 and continuing.
[TABLE="width: 602"]
<tbody>[TR]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THU[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THU[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A - 9[/TD]
[TD]A-9[/TD]
[TD]S-4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] H[/TD]
[TD][/TD]
[TD]S-9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to sum the rightmost number for each such that I have a sum for A of 18 and another cell has a sum of 13 for S. I've looked at SUMIF, SUMIFS, LEFT, RIGHT, IF, IF THEN etc but can't seem to work this out. It seems to be the combination of checking for the left most character to sum the rightmost character is throwing a glitch.
I would appreciate any help you can provide. Thank You.
I was given a tracking spreadsheet that I want to automate counts. Each row has the 14 days of the 2 week payperiod beginning in D9 through Q9:
[TABLE="width: 602"]
<tbody>[TR]
[TD="class: xl64, width: 43"]SUN[/TD]
[TD="class: xl64, width: 43"]MON[/TD]
[TD="class: xl64, width: 43"]TUE[/TD]
[TD="class: xl64, width: 43"]WED[/TD]
[TD="class: xl64, width: 43"]THU[/TD]
[TD="class: xl64, width: 43"]FRI[/TD]
[TD="class: xl64, width: 43"]SAT[/TD]
[TD="class: xl64, width: 43"]SUN[/TD]
[TD="class: xl64, width: 43"]MON[/TD]
[TD="class: xl64, width: 43"]TUE[/TD]
[TD="class: xl64, width: 43"]WED[/TD]
[TD="class: xl64, width: 43"]THU[/TD]
[TD="class: xl64, width: 43"]FRI[/TD]
[TD="class: xl64, width: 43"]SAT[/TD]
[/TR]
</tbody>[/TABLE]
Previously entered data would be such as under Monday A-9, Tuesday A-9, Wed S-4, etc. in D10:Q10 and continuing.
[TABLE="width: 602"]
<tbody>[TR]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THU[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[TD]SUN[/TD]
[TD]MON[/TD]
[TD]TUE[/TD]
[TD]WED[/TD]
[TD]THU[/TD]
[TD]FRI[/TD]
[TD]SAT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A - 9[/TD]
[TD]A-9[/TD]
[TD]S-4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] H[/TD]
[TD][/TD]
[TD]S-9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to sum the rightmost number for each such that I have a sum for A of 18 and another cell has a sum of 13 for S. I've looked at SUMIF, SUMIFS, LEFT, RIGHT, IF, IF THEN etc but can't seem to work this out. It seems to be the combination of checking for the left most character to sum the rightmost character is throwing a glitch.
I would appreciate any help you can provide. Thank You.