Reputation
660
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 9 30
Impact
~107k people reached

Jul
25
revised PivotTable — how to sum the result of a countif formula by group?
removed link to file due to business restrictions.
Jul
25
comment PivotTable — how to sum the result of a countif formula by group?
While I didn't use this exact technique, I realized that calculating per line on the table (in hidden columns) and then using the pivottable to sum is the easiest way in this case. Thanks for helping me see the simpler answer!
Jul
25
accepted PivotTable — how to sum the result of a countif formula by group?
Jul
25
comment PivotTable — how to sum the result of a countif formula by group?
Eventually, I'd like to also to sum up the total purchase cost and total yearly cost from the calculated fields I mention in the comment above as well.
Jul
25
comment PivotTable — how to sum the result of a countif formula by group?
The pivot table shows the sum of each type of license per group. I'd essentially like the following additional fields: full license cost (pivot sum * B16), full license maintenance (PT sum * B19), limited license cost (pt sum * B17), and limited license maintenance (pt sum * B20)
Jul
25
revised PivotTable — how to sum the result of a countif formula by group?
Added a link to the file in question
Jul
25
asked PivotTable — how to sum the result of a countif formula by group?
Apr
1
awarded  Popular Question
Feb
9
awarded  Popular Question
Feb
8
awarded  Notable Question
Jan
10
accepted SATA 6Gb/s vs. 3Gb/s when using SSD Caching via Intel RST?
Jan
10
asked SATA 6Gb/s vs. 3Gb/s when using SSD Caching via Intel RST?
Nov
18
awarded  Self-Learner
Nov
15
awarded  Popular Question
Nov
9
accepted Windows 7 install issues with 2x3TB in RAID1
Nov
5
answered Windows 7 install issues with 2x3TB in RAID1
Nov
4
revised Windows 7 install issues with 2x3TB in RAID1
corrected minor spelling (UEFI instead of EUFI).
Nov
4
revised Windows 7 install issues with 2x3TB in RAID1
formatting.
Nov
4
comment Windows 7 install issues with 2x3TB in RAID1
So It sounds like what you're saying is that the drives are partitioned with MBR by default? Win7 setup with bare disks is what led to this. I'm looking into how to use diskpart to achieve the desired partitioning.. Regarding AHCI mode vs. RAID mode: I have the Intel controllers set to RAID mode and the Marvel controller set to AHCI. I've since unplugged the SSD to remove it from the equation.
Nov
4
comment Windows 7 install issues with 2x3TB in RAID1
so since I've updated the Asus P8Z68-V/Pro Gen3 mobo to the latest firmware, this should include the updated driver for the Intel Z68 chipset's native RAID1 support? I've updated the firmware but while the BIOS sees it correctly, windows does not. It seems I need to partition the drives using GPT -- looking into whether that would solve the problem. Was curious as to whether additional drivers at Win7 install startup would have solved it. Can't find any sort of download for this scenario..