| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF & MEDIAN with blanks & text
The formula you provided does have an error in it somewhere
Yeah, my fault. I used the wrong range! Try this one (array entered): =IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,0)),$B3,Qualified),AVERAGE(IF((INDIRECT (VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,0))=$B3 )*(Qualified<""),Qualified)),"-") -- Biff Microsoft Excel MVP "Brian" wrote in message ... LOL - this sheet is pretty ugly but it does do as intended for better or worse. The formula you provided does have an error in it somewhere - I'll take a look and see if it's a missing paratheses, but I don't think is the issue. =IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,0)),$B3,Qualified),AVERAGE(IF(INDIRECT( VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,0))=$B3) *(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY ,3,0))<""),Qualified)),"-") "T. Valko" wrote: This is going to be really ugly! =IF(SUMIF(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Ty pe_ARRAY,3,0)),$B3,Qualified),AVERAGE(IF(INDIRECT( VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY,3,0))=$B3) *(INDIRECT(VLOOKUP(Stats_Dropdown,Stats_Type_ARRAY ,3,0))<""),Qualified)),"-")--BiffMicrosoft Excel MVP |
| 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
