ExcelBanter - View Single Post

[email protected]

wrote:
Thanks that helped but I ran into another problem.
Cycle 1 Jan. 1- Jan. 14
1/1 Status OT TD 1/8 Status OT TD
1/2 1/9
[....]
1/7 1/14
Totals Reg. 0 OT TD
Hol. Sick
In the status column is where the letter P will be entered. At the 0
next to regular hours, I need P to enter in the formula along with
other number values that are present. An example would be at 1/2-P, at
1/4-8. So next to Reg. should be the #20.25. I cannot get this
portion to work.

First, I am not sure you fully understand what Chip suggested. You
would enter =P in the appropriate cell in the Status column, not simply
P. You will see 12.25, not P. Is that what you truly wanted?

Second, I presume that what you want in the cell next to Reg is
something like:

=sum(B2:B8,F2:F8)

where B2:B8 and F2:F8 are the Status cells for the dates 1/1 through
1/7 and 1/8 through 1/14 respectively. Thus, if you have =P in the
Status cell for 1/2 and 8 in the Status cell for 1/4, the sum will be
20.25.