Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 3 13
Impact
~22k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
May
12
awarded  Notable Question
Mar
20
awarded  Notable Question
Dec
17
awarded  Famous Question
Oct
21
awarded  Popular Question
Sep
24
awarded  Autobiographer
Sep
8
awarded  Popular Question
Sep
5
awarded  Popular Question
Jan
6
accepted PowerPivot Bar is grayed out
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))}