Sep 27 2019 04:40 AM - edited Sep 27 2019 05:21 AM
Can I give a cell a value without that value being in the cell? I need to work out TOTAL HOURS/WEEK based on the cells with 'X' being worth a certain number of hours (either 2.5 or 1). Can anyone please help with the correct formula(s)?
Name | TOTAL HOURS/ WEEK | Session Mon A.M. 2.5 Hours | Session Mon P.M. 1 Hour | Session Tues A.M. 2.5 Hours | Session Tues P.M. 1 Hour | Session Wed A.M. 2.5 Hours | Session Wed P.M. 1 Hour |
Freddie | x | x | x | ||||
Bobby | x | x | x | x | x | x | |
Margi | x | x | x | x |
Sep 27 2019 05:08 AM
Why not upload a small sample file with some dummy data (not an image of data) along with desired output mocked up manually so that it would be easy to visualize what exactly you are trying to achieve.
Sep 27 2019 06:03 AM
@Subodh_Tiwari_sktneer Thanks for the advice, I'm new to this! I've added a table which hopefully helps explain my query a bit better! Many thanks
Sep 27 2019 06:29 AM
SolutionIf you insert a row to have the Hours as shown below...
You can simply use the SUMIF formula in B2 and copy it down.
=SUMIF(C3:H3,"x",$C$2:$H$2)
Sep 27 2019 06:54 AM
Sep 27 2019 07:54 AM
You're welcome!
If that resolves your question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.
Sep 27 2019 06:29 AM
SolutionIf you insert a row to have the Hours as shown below...
You can simply use the SUMIF formula in B2 and copy it down.
=SUMIF(C3:H3,"x",$C$2:$H$2)