Latest Lists

How to keep track of people in excel?

I want to keep an ongoing list of participants in a charity that I work with. I would like to keep an ongoing daily list of all participants and show which of 4 services they used for that day. I want to also be able to determine over a month for example how many showers some one took without doing a alpha sort and just manually counting. Thanks for any help

Public Comments

1. Hi, WIthout more information I can't really provide too much assistance but one function of excel which should help you is the countif and sumif functions. Ordinarily the sum and count functions sum and count unconditionally however the sumif and countif functions allow a criteria to be incorporated into the mix. For example if you wanted to count the total number of records with the name "bob" in them you could do it like so: ....... A..................... .........B ......... ........... ..............C 1 ...Name................... .....Shower . ................ ..... ..Bathroom 2...Bob ................ .............2............ ................... .....3 3...John .................. ..........1... ......................... ........2. 4...Bob ........................ .....1................ ............. .......4 5...Paul .................... ........2.......... ................ ...........2 6...Total for Bob ... =SUMIF($A$2:$A$5,"Bob",B2:B5)... =SUMIF($A$2:$A$5,"Bob",C2:C5) This translates to: ....... A..................... .........B ......... ........... ..............C 1 ...Name................... .....Shower . ................ ..... ..Bathroom 2...Bob ................ ............(2)............ .................. ....(3) 3...John .................. ..........1... ......................... ........2. 4...Bob ........................ ....(1)................ ........... .......(4) 5...Paul .................... ........2.......... ................ ...........2 6...Total for Bob ... .... ....... (3). ............... ................. .(7) The countif function works similary however it counts how many time Bob's name appears in the list (regardless of how many times he showered or used the bathroom). In other words the countif function =countif(A2:A5,"Bob") would return the value 2. Hope this helps a bit.