"IF" Formula

[Guest]

xl2000—Totaling time worked at each of three stores for a two-week pay
period. What I have is Columns C, D, E, F, G, H, & I, are week one. Columns
M, N, O, P, Q, R, S, are week two. I have, through data validation,
dropdowns to select Store 1, Store 2, or Store 3, in row 7 of each of the
described columns. The employee will select the store worked for that day,
by column (C> Monday, D>Tuesday, E> Wednesday, etc). Then enter the time
worked in the same column. In row 18 are the total hours for each day
worked. Now I need to summaries the time worked for each store throughout
the two week time period. Summaries are in C25 for Store 1, E25 for Store 2,
and G25 for Store 3. I think I need an IF formula in C25, E25, and H25 to
bring these totals together for each store, but do not know how to do it. It
seems to me, in C25 for instance, it needs to be something like IF Store 1
(in the dropdown box C7) then add C18, IF Store 2??? IF Store 3??? I would
have to include all 14 columns into the formula. From there I am lost!!!
Thanks for your help>

Mike R.

 

[Peo Sjoblom]

How about using SUMIF? The stores are in row 7 and the time in 18

=SUMIF(C7:I7,"Store 2",C18:I18)+SUMIF(M7:S7,"Store 2",M18:S18)

Don't know what you have in jkl but you might be able to use

=SUMIF(C7:S7,"Store 2",C18:S18)


will give you the total hours for store 2, to display the time use a custom
format of [hh]:mm

 

[Guest]

Peo

Thanks again you hit a home run for me. I had to use the first option you
gave me because there is other information in the three cells separating the
weeks. One last really simple question. Does one need to make these cell
referances absolute to copy and paste them without the cell referances
changing?
Thanks again!!!!

Mike R.

How about using SUMIF? The stores are in row 7 and the time in 18

=SUMIF(C7:I7,"Store 2",C18:I18)+SUMIF(M7:S7,"Store 2",M18:S18)

Don't know what you have in jkl but you might be able to use

=SUMIF(C7:S7,"Store 2",C18:S18)


will give you the total hours for store 2, to display the time use a custom
format of [hh]:mm


--

Regards,

Peo Sjoblom

xl2000-Totaling time worked at each of three stores for a two-week pay
period. What I have is Columns C, D, E, F, G, H, & I, are week one. Columns
M, N, O, P, Q, R, S, are week two. I have, through data validation,
dropdowns to select Store 1, Store 2, or Store 3, in row 7 of each of the
described columns. The employee will select the store worked for that day,
by column (C> Monday, D>Tuesday, E> Wednesday, etc). Then enter the time
worked in the same column. In row 18 are the total hours for each day
worked. Now I need to summaries the time worked for each store throughout
the two week time period. Summaries are in C25 for Store 1, E25 for Store 2,
and G25 for Store 3. I think I need an IF formula in C25, E25, and H25 to
bring these totals together for each store, but do not know how to do it. It
seems to me, in C25 for instance, it needs to be something like IF Store 1
(in the dropdown box C7) then add C18, IF Store 2??? IF Store 3??? I would
have to include all 14 columns into the formula. From there I am lost!!!
Thanks for your help>

Mike R.

 

[Peo Sjoblom]

Yes, select (high light) the whole formula in the formula bar, then press F4
to toggle
different references

--

Regards,

Peo Sjoblom

Peo

Thanks again you hit a home run for me. I had to use the first option you
gave me because there is other information in the three cells separating the
weeks. One last really simple question. Does one need to make these cell
referances absolute to copy and paste them without the cell referances
changing?
Thanks again!!!!

Mike R.

How about using SUMIF? The stores are in row 7 and the time in 18

=SUMIF(C7:I7,"Store 2",C18:I18)+SUMIF(M7:S7,"Store 2",M18:S18)

Don't know what you have in jkl but you might be able to use

=SUMIF(C7:S7,"Store 2",C18:S18)


will give you the total hours for store 2, to display the time use a custom
format of [hh]:mm


--

Regards,

Peo Sjoblom

xl2000-Totaling time worked at each of three stores for a two-week pay
period. What I have is Columns C, D, E, F, G, H, & I, are week one. Columns
M, N, O, P, Q, R, S, are week two. I have, through data validation,
dropdowns to select Store 1, Store 2, or Store 3, in row 7 of each of the
described columns. The employee will select the store worked for that day,
by column (C> Monday, D>Tuesday, E> Wednesday, etc). Then enter the time
worked in the same column. In row 18 are the total hours for each day
worked. Now I need to summaries the time worked for each store throughout
the two week time period. Summaries are in C25 for Store 1, E25 for

Store
2,

and G25 for Store 3. I think I need an IF formula in C25, E25, and H25 to
bring these totals together for each store, but do not know how to do

it.
It

seems to me, in C25 for instance, it needs to be something like IF Store 1
(in the dropdown box C7) then add C18, IF Store 2??? IF Store 3??? I would
have to include all 14 columns into the formula. From there I am lost!!!
Thanks for your help>

Mike R.