| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum all numeric values in this formula
I have the following formula:
=SUM(E45,H45,K45,N45,Q45,T45,W45,Z45,AC45,AF45) I can't make it a Sum(E45:AF45) because other values are present. I've used something like Sum(if(isnumber(E45:H45),E45:H45)), but it doesn't seem to work when I have (E45,H45,K45) in the range. Can someone assist? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Non Numeric Values | Charts and Charting in Excel | |||
| Matching numeric values. | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Text values to numeric values | Excel Discussion (Misc queries) | |||
Threaded Mode
