| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OK i need help with the if function.
Pls help me. My current column formula is =SUM(LARGE(B8:B15,{1,2,3,4,5,6})).
that get's me the top 6 values i need, but only if values are entered. If I do not put values in cells 8:15 i get #NUM! as a result. This formula is being used in 5 columns (b,c,d,e,f). The totals are in cell 16 for each column. I need to get the value 0 WHILE LEAVING THE CELLS EMPTY because I grand total the totals by using the formula =SUM(B16:F16). That formula won't unless it has at least a value of 0 for each column, or it returns the #NUM! also. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
