midwestmarinemom
New Member
- Joined
- Sep 14, 2011
- Messages
- 1
I am trying to format a timesheet. I've successfully formatted in/out, in/out for a day and the regular, overtime calculations based on hours worked in a 40 hour week. These hours are often split by different locations (G/L codes). I have learned how to sum conditionally, but I'd like the next column to say what pay code (G/L code) it is that I'm summing. Is that possible. Example:
Hrs Worked (column O) G/L Code (column P).
My conditional sum statement says: sumif((P7:P12),U7,(O7:O13)) (I manually typed each G/L code in column U)
U7 is the column I have listed the G/L codes in, and we have many - 1,000 +
P7:P12 = G/L Code O7:012= Hours worked
My question, instead of a column with 1,00+ G/L codes(column U), can I say look at the data in column P (G/L code), and if it's = to ( something denoting a particular G/L code), then sum the numbers in column O (hours worked) and in the next column label the G/L code you just summed in the column next to the summing result, what does the total represent? I hope this makes sense and I'm grateful for any assistance provided.
Thanks!
Hrs Worked (column O) G/L Code (column P).
My conditional sum statement says: sumif((P7:P12),U7,(O7:O13)) (I manually typed each G/L code in column U)
U7 is the column I have listed the G/L codes in, and we have many - 1,000 +
P7:P12 = G/L Code O7:012= Hours worked
My question, instead of a column with 1,00+ G/L codes(column U), can I say look at the data in column P (G/L code), and if it's = to ( something denoting a particular G/L code), then sum the numbers in column O (hours worked) and in the next column label the G/L code you just summed in the column next to the summing result, what does the total represent? I hope this makes sense and I'm grateful for any assistance provided.
Thanks!
Last edited:
