Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a user who is trying to add a number of different cells toghehter.
Sometimes they have a value and sometimes they are blank. The formula is evulating to #Value!. This is the formula: I16+K16+M16+O16+Q16+S16+U16+W16+Y16+AA16+AC16+AE16 I tried changing it to this: (IF(ISBLANK(I18), 0, I18))+ IF(ISBLANK(K18), 0, K18)+ IF(ISBLANK(M18), 0, M18)+ IF(ISBLANK(O18), 0, O18)+ IF(ISBLANK(Q18), 0, Q18)+ IF(ISBLANK(S18), 0, S18)+ IF(ISBLANK(U18), 0, U18)+ IF(ISBLANK(W18), 0, W18)+ IF(ISBLANK(Y18), 0, Y18)+ IF(ISBLANK(AA18), 0, AA18)+ IF(ISBLANK(AC18), 0, AC18)+ IF(ISBLANK(AE18), 0, AE18) I am still getting the error. What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
Adding cells with alphabet and returning a numbric value | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
ADDING CELLS WHICH ARE <> THAN OTHER CELLS | Excel Worksheet Functions |