Forum Discussion
Solved
Can I give a cell a hidden value and then add hidden value up?
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 ...
If 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)
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
If 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)
- Thank you!!!
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.