Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignoring Dates in Sums
I have a very lengthy column which includes data of various sorts: some cells
are textual, some have dates, and others are numbers. I need to add the values in only the cells that have numbers. The SUM formula disregards text, so those cells don't pose a problem, but the date cells skew my results if I use some (since they get included in their converted representation). Is there an easy way to add only numerical (ie, non-date and non-textual) values? On a similar note: Is there a quick way to count the cells that have text in them? I don't need a sum in this case: Just a count of the cells. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) |