bio | website | |
---|---|---|
location | California | |
age | 35 | |
visits | member for | 2 years, 3 months |
seen | Jan 6 at 22:48 | |
stats | profile views | 21 |
Here to learn about R and data mining/predictive modeling. I am new to these topics but have a business and analytical background...
Sep 8 |
awarded | Popular Question |
Sep 5 |
awarded | Popular Question |
Jan 6 |
accepted | PowerPivot Bar is grayed out |
Dec 20 |
asked | Calculating Annualized Turnover in Excel PowerPivot |
Dec 20 |
answered | PowerPivot Bar is grayed out |
Dec 20 |
revised |
Calculating Annualized Turnover in a Pivot Table or PowerPivot
Expanded question |
Dec 20 |
answered | Calculating Annualized Turnover in a Pivot Table or PowerPivot |
Dec 20 |
comment |
PowerPivot Bar is grayed out
I figured out how to create a new measure which is ultimately what I was trying to figure out how to do as a next step. But it feels like I ought to be able to do this from the ribbon. I can't. To add a new measure I have right click on the table name in the PowerPivot Field List window. Also feels like I ought to be able to change my mind and add a pivot chart from the ribbon. But again I can't. I have to go back to the linked PowerPivot data table. What am I missing here? |
Dec 19 |
comment |
PowerPivot Bar is grayed out
But what if I want to add calculated measures? |
Dec 19 |
asked | PowerPivot Bar is grayed out |
Dec 19 |
asked | Calculating Annualized Turnover in a Pivot Table or PowerPivot |
Sep 9 |
awarded | Editor |
Sep 9 |
comment |
Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
You know I was wondering about that last scenario but didn't even think to press my luck and ask. Thanks again. Great job! |
Sep 9 |
accepted | Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010 |
Sep 9 |
comment |
Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
Awesome that works! Please post this as an answer and I will accept it. |
Sep 9 |
comment |
Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
BTW I tried CSE and using sumproduct and using a range instead but still didn't work: {=SUMPRODUCT(COUNTIF(A27:A27,search_items1))} |
Sep 9 |
comment |
Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
will what I'm trying to do is for each cell (thus the single cell reference instead of a range) count number of instances for example cell A1 might have "LBNL" or "LBL" or both. In the case of the first two the formula should return 1 and in the case of the second 2. For me it only works for the first item in the name range. So it will count a cell with single text of "LBNL" but if it has "LBNL LBL" it will return 0 instead of 2. Are you sure its working for you? Does it return 2 for you in the latter example? |
Sep 9 |
awarded | Commentator |
Sep 9 |
comment |
Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
btw I am trying to avoid VBA if at all possible |
Sep 9 |
asked | Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010 |