K
kiamm
Hello All,
I've been trying to find a formula that will sum certain criteria and
haven't been able to get the correct results, please someone let m
know what I'm doing wrong.
Example:
I have a one year calendar and on this year to date calendar I want t
keep track of certain time off (vac, sick, personal etc...)
In cell L27 is V and in cell M27 is 8, meaning this person too
Vacation time and used 8 hours. This continues through out and ends a
cel BU27. ex. ( N27=V, O27=8) (P27=S, Q27=8).
The formula that I've tried is SUMIF(L27:BU27,"V",L27:BU27)
This is giving me a value and not calculating correctly.
I want the formula to look up columns L27:BU27 and if they are = to "V
then I want it to sum 1 column over to the right (ex. above if L27 =
then sum M27= 8) and so on but it's not doing this.
PLEASE HELP!!!!
I've been trying to find a formula that will sum certain criteria and
haven't been able to get the correct results, please someone let m
know what I'm doing wrong.
Example:
I have a one year calendar and on this year to date calendar I want t
keep track of certain time off (vac, sick, personal etc...)
In cell L27 is V and in cell M27 is 8, meaning this person too
Vacation time and used 8 hours. This continues through out and ends a
cel BU27. ex. ( N27=V, O27=8) (P27=S, Q27=8).
The formula that I've tried is SUMIF(L27:BU27,"V",L27:BU27)
This is giving me a value and not calculating correctly.
I want the formula to look up columns L27:BU27 and if they are = to "V
then I want it to sum 1 column over to the right (ex. above if L27 =
then sum M27= 8) and so on but it's not doing this.
PLEASE HELP!!!!