I have a spreadsheet in which I need to count how many reports have been sent, currently i put the date in and manually input the total number of reports sent, but is there a formula I can put in so once a date is input into a cell it automatically 'counts' the number of cells with dates in them?
2007-04-25 02:54:07 · 6 answers · asked by Christine 6 in Computers & Internet ➔ Software
thanks you, got it working
2007-04-25 03:25:06 · update #1
lets say that the dates are in column A. the formula you would need to count the non blank cells would be =countif(A:A,"<>") as long as the cell is not blank it will be counted.
2007-04-25 02:59:05 · answer #1 · answered by Anonymous · 3⤊ 0⤋
Go to Excel help.
Search for "Count cells that contain numbers, etc."
2007-04-25 10:00:33 · answer #2 · answered by ed 7 · 0⤊ 0⤋
Yes. Use the function "COUNTIF" (count the range of cells with in a range that meet the given condition)
Hope it helps.
2007-04-25 09:59:24 · answer #3 · answered by exo 7 · 0⤊ 0⤋
The following is a links regarding counting cells:
http://www.techonthenet.com/excel/formulas/count.php
http://www.meadinkent.co.uk/xlsumavgct.htm
http://www.ozgrid.com/Excel/count-if.htm
http://www.ozgrid.com/Excel/excel-count-one-occurrence.htm
http://j-walk.com/ss/excel/tips/tip52.htm
2007-04-25 10:02:36 · answer #4 · answered by CB 3 · 0⤊ 0⤋
for this you can use count formula
=count(cell n:cell n)
2007-04-25 10:01:33 · answer #5 · answered by krishna 1 · 0⤊ 0⤋
=counta()
2007-04-25 10:00:01 · answer #6 · answered by Anonymous · 0⤊ 0⤋