i do these reports on how much money people collect every day. not everyone works every day so some days on the spreadsheet are blank for them. at the end of the month i take everyone's totals and i divide the monthly total collected by the number of days they worked... the only way i know how to do this is to actually count the number of days they work and manually type out "=sum(b32/12)"... saying they worked twelve days and b32 is the cell with the montly total in it.. is there a way to make an excel formula that picks up how many enteries there were for this person during a given range and divde by that? thanks!
2006-06-06
07:32:24
·
10 answers
·
asked by
rishathra7
6
in
Software