I am trying to make a function that sum everything within a column by some criteria.
Below i have column AE. i need to sum every value that corresponds to CB-01 (column AC) after that everything that corresponds to CB-02 and so on… can you help me with this issue?
Answers
Hi. I use an online app at work that calculates my hours worked per day but it is always going wrong.
Has anyone got a spreadsheet that I can use to keep a manual record ?
It needs to have Time in Time out, Time in Time out as we obviously log out at lunchtime.
It also needs to compare my daily total to the standard 7 hours per day to see if I am plus or minus each day.
Would be great if there is one that does it weekly and feeds into a monthly report as well for carry over at end of month. Can’t find anything suitable online.
Answers
Hello, Kriti I’ve been searching for hours… I’m trying to freeze the top row AND freeze either the image OR the cells that I labeled (just for this inquiry).
When the user scrolls, I want either one to remain visible to the user. I plan on deleting whichever one I am not able to freeze.
Does anyone know how to accomplish this??
Answers
