IF statements and Finding text in one column and displaying value in adjacent column

jrace,

Welcome to the forum!
For your first question, this formula in cell B30 should do the trick:

Please Login or Register  to view this content.

For your second question, you just need a Sumif() formula. For example, in cell B31 (Holiday Hrs), the formula would look like this:

Please Login or Register  to view this content.

Copy that sumif formula to the other cells that need to be summed by code and change the code you're looking for from "H" to the appropriate code.

It works fine for me... can you supply a sample workbook that is experiencing the issue?

jrace,

From your original post:

Originally Posted by jrace

Second I Need to display any of the numerical values that may be entered in column N21:N28 to populate in the corresponding cells at the bottom of the sheet based on the Code values that may be entered into column M21:M27 (H, LWOP, M, F, J ML, D, FS)

Using that information, I provided the Sumif formula that only looks in that range of cells. You have used that formula, but then put the code and hours outside that range of cells. You put the code in cell M13 (with its corresponding hours in N13). That is not within the range of rows 21:27, so the formula isn't looking there and so that information never gets summed. If you want to include that range, you'll need to adjust where the formula is looking:

Please Login or Register  to view this content.