| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT - How To
On Sep 6, 10:22 am, "Peo Sjoblom" wrote:
Please explain the difference........ I thought once you give it the range and the variable after , is the one that it suppose to count.....? No, I assume you have looked at it in help and frankly the example does not make any sense, all it does is to add 1 count to the total. It will not differentiate between 0 or 2 in the range you are using so it is not a variable that COUNT uses to count all zeros (in your example), who wants to count the cells that contain numeric values in let's say A1:A10 then add another numeric value hard coded, you might as well use? =COUNT(D2:D567)+1 All I can say is that although you can use COUNT with criteria (you can if you use array formulas) in this case it would be insane since COUNTIF will do the work. -- Regards, Peo Sjoblom Thanks for the info....... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
