| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting if
Ok. Trying to determine how to have Excel count the number of cells where
the numerical data is a whole number when divided by 10. I know it can be done with VBA, but don't know enough to know how and thought should be possible with the canned product. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting if
With the numbers in A1:A100
=SUMPRODUCT(--(MOD(A1:A100,10)=0),--(A1:A100<"")) Regards, Peo Sjoblom "Kat" wrote: Ok. Trying to determine how to have Excel count the number of cells where the numerical data is a whole number when divided by 10. I know it can be done with VBA, but don't know enough to know how and thought should be possible with the canned product. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional counting with Excel | Excel Worksheet Functions | |||
| counting rows with same values for multiple values | New Users to Excel | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
| Counting... | Excel Worksheet Functions | |||
Linear Mode
