Dear Forum-
I would greatly appreciate any assistance in a way to accomplish my goal with a spreadsheet.
I'm trying to make a running, daily log, where the user is presented with a drop down list of activities to choose from, and then they just need to put the date, and how long they did that activity. So in a given day, they may have 3 or 4 entries, with various activities and times allotted.
Then I would like it to calculate how many times they have done each activity, and how many hours they have done each activity, in total.
I have a visual backbone (attached) of what I'm trying to do, and I can get my "IF" statements working for a singular activity, but as far as counting the number of each activity, is where I the wheels fall off for me, among other issues!
For example, I can successfully do an IF function, say IF cell "blank" equals "someactivity" then return a "1", if not, return a "0". I guess I would like to know if you can do an IF function that will check for multiple values... and then give you a count for each one going down the log? Or am I just going to have to do a billion hidden function cells that will eventually do all the math behind the scenes.
I've attached what I have so far and hopefully it's not too pitiful.
Thank for any help!
Sincerely,
Jim
Bookmarks