Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-17-2014, 01:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Average if and sumif Windows 7 64bit Average if and sumif Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

As for your last question you could either use the GETPIVOTDATA function ( not very flexible) or have a look at this article.
Using the free POWERPIVOT add-in also has it's advantages, but I can't help you much with that one.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average if and sumif SUMIF results changed based on filters SteveBump Excel 5 10-29-2013 07:25 AM
Help! 'SUMIF' Formulas dave1372 Excel 2 09-08-2011 07:05 AM
Average if and sumif SUMIF Formula question jcaswell Excel 3 05-22-2011 02:52 AM
Average if and sumif Need Help With SUMIF Formula In R1C1 Style Todd Excel 9 02-27-2010 08:30 PM
Average if and sumif Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft