| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add numbers in a column, but exclude percentages in the same colum
First of all, I did not set this spreadsheet up, but maybe I can learn
something . . . I have a user who needs to add a column of numbers. The problem is that there are also percentages in this same column. The percentages cannot be added in. Initially, I had him use the formula: =SUMIF(A1:A35,"=1"), ASSUMING that any non-percentage was above 1. Unfortuantely, this is not the case. Can I modify this formula or use another formula so that it can tell that a cell is formatted as percentage? Thanks in advance. Rich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentages and whole numbers | Excel Worksheet Functions | |||
| show a column of numbers also as percentages | Excel Worksheet Functions | |||
| ranking a colum of numbers | Excel Worksheet Functions | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| Count 350 SS numbers, exclude duplicates | Excel Discussion (Misc queries) | |||
Threaded Mode
