Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Given the next example:
COLUMN A ROW1 27.35 ROW2 112.01 ROW3 3.75 ROW4 #N/A ROW5 4.55 ROW6 #N/A ROW7 I want to enter a formula on cell A7 that will find all of the cells that ARE NUMBERS, and then return the SUM of those cells. I asked this before, but making comparisons vs. zero or vs. very large negative numbers does not work. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to generate random numbers from a range of cells? | Excel Worksheet Functions | |||
How do I prevent duplicate numbers in a range of validated cells? | Charts and Charting in Excel | |||
How do i get the top 5 numbers in a range of cells? | Excel Worksheet Functions | |||
How do i get the top 5 numbers in a range of cells? | Excel Worksheet Functions | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) |