Friday, February 28, 2014

yogi_Keep A Cumulative Count Of Hours By Name 1 Hour For Each Instance Of Name In A Calendar

                                         Google Spreadsheet   Post  #1548
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-23-2014
post by Mike Bailey 1 (!msg/docs/i3md8VPZheo/ujqg9OUhKPkJ)
Count and Tally

I am extremely untalented with spreadsheets and Excel, so excuse me if this is day 1 stuff !

I am populating (manually) cells in a "calender" with one of a possible n names (text)
When fully populated, the Calender might have 2 or 3 different names spread over 12 hours, on each day.
I can count the total number of "hours" for each name easy enough (it seems) but what I would also like
to do is this.

1 John
2 John
3 John
4 Adam
5 Adam
6 Phil
7 Phil
8 Phil

in column B, next to each name, I would like to have a cumulative counter of hours at that point.
So B1 would be 1 for John, B2, 2 for John, but B4 would be 1 for Adam, B5 2 for Adam etc
Thing is, I need to check who is in A first as I have a fixed list of names.

Any help would be great, I have not actually made a sheet yet..I am stuck on step 1 !
I made a test (please don't laugh)  :)

so..I can count the total hours, for any name in the whole month day.
Now I would like to start adding up the hours for each name, in the column next to it.

Does that make sense?

have a look at my convoluted solution -- I have shown formulas for 1st week only -- these can be extended to subsequent weeks