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 Computers & Internet ➔ Software
count! that's exactly what i needed. i love you all! <3<3<3
2006-06-06 07:54:26 · update #1
=B32/COUNT(B1:B31) assuming that B1:B31 includes all the days worked.
2006-06-06 07:52:49 · answer #1 · answered by bloggerdude2005 5 · 5⤊ 3⤋
The function is COUNTA
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.
Syntax
COUNTA(value1,value2, ...)
Value1, value2, ... are 1 to 30 arguments representing the values you want to count. In this case, a value is any type of information, including empty text ("") but not including empty cells. If an argument is an array or reference, empty cells within the array or reference are ignored. If you do not need to count logical values, text, or error values, use the COUNT function.
I found this using Microsoft Excel Help
2006-06-06 07:37:42 · answer #2 · answered by Caffiend 3 · 0⤊ 0⤋
Take sum(B1:B32)/12 assuming B1 starts the cell for the person. Excel will ignore the empty cell for you.
2006-06-06 07:36:42 · answer #3 · answered by cmalu 2 · 0⤊ 0⤋
Use sumif function in the excel. U can get the best explanation from excel help. Type sumif in the search box of help (or assistant's dialog). Ur problem will surely be solved
2006-06-06 07:38:08 · answer #4 · answered by ssans 2 · 0⤊ 0⤋
You can have excel do a COUNT of non-blank fields, check with the help function to find out how to use it in your case
2006-06-06 07:36:07 · answer #5 · answered by thepathfinder804 3 · 0⤊ 0⤋
I need help writing this can someone help? Look for value in A1 in column C1 then return value in D1
2014-10-29 10:04:46 · answer #6 · answered by In out 1 · 0⤊ 0⤋
=COUNTBLANK(B1:B32) would give you the number of blank cells.
so
=32-COUNTBLANK(B1:B32) gives the number of non-blank cells. Be careful not to have a space in any cell.
2006-06-06 07:35:28 · answer #7 · answered by Anonymous · 0⤊ 0⤋
a couple of "if"s and a couple of fields will do the trick. But still not sure what yo're really trying to do..
2016-03-26 21:06:41 · answer #8 · answered by Anonymous · 0⤊ 0⤋
contact me i have something made like this i would need some more info from you to help you out with it. if you have msn add me
burhan_farooqui@hotmail.com
2006-06-06 07:36:40 · answer #9 · answered by Burhan 2 · 0⤊ 0⤋
how about sum(a1:a10)/count(a1:a10)
2006-06-06 07:35:51 · answer #10 · answered by Dan in Boston 4 · 0⤊ 0⤋