| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF & MEDIAN with blanks & text
I had some help putting together this formula, but it has been giving me some
grief for some reason after it seemed to work ok to start with..... =IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,FALSE)),$C3,Qualified),MEDIAN(IF(INDIRE CT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,FALSE ))=$C3,Qualified)),"-") The data it is evaluating can have text, blanks, or numbers in the range, "Qualified." In this case, it only has numbers and blanks. MEDIAN shouldn't have an issue delaing with blanks/deleted cells and the formula above works fine in other cases where there are blanks. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median - Ignore blanks | Excel Discussion (Misc queries) | |||
| =sumif(a1:a3,"median(a1:a3)") always gives 0. What to do? | Excel Worksheet Functions | |||
| removing blanks at the end of text | Excel Worksheet Functions | |||
| Advanced filtering on text and blanks | Excel Discussion (Misc queries) | |||
| Detecting Blanks and Non Text Characters. | Excel Worksheet Functions | |||
Threaded Mode
