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     www.energyefficientbuild.com.   Feb-23-2014
post by Mike Bailey 1 (https://productforums.google.com/forum/#!msg/docs/i3md8VPZheo/ujqg9OUhKPkJ)
Count and Tally

Hello,

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.

 A

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)  :)

https://docs.google.com/spreadsheet/ccc?key=0AlH72vN1OMS8dEUtcFA0QVU3R3RiMmM3ckpVX2xXWlE&usp=sharing

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