Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-17-2014, 08:32 PM
macropod's Avatar
macropod macropod is online now formula to find 2 or more criterias then average the sum Windows 7 32bit formula to find 2 or more criterias then average the sum Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could use:
=INDEX(Assessment!$AB$1:$AB$6,MATCH($A3&H$2,Assess ment!$A$1:$A46&TEXT(Assessment!$F$1:$F6,"MMMM"),0) )
as an array formula. This will output either the amount in AB if a match is found or '#N/A' if not. To display only matches would require:
=IF(ISERROR(INDEX(Assessment!$AB$1:$AB$6,MATCH($A3 &H$2,Assessment!$A$1:$A46&TEXT(Assessment!$F$1:$F6 ,"MMMM"),0))),"",INDEX(Assessment!$AB$1:$AB$6,MATC H($A3&H$2,Assessment!$A$1:$A46&TEXT(Assessment!$F$ 1:$F6,"MMMM"),0)))
again, as an array formula.

Array formulae are input with Ctrl-Shift-Enter.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to find 2 or more criterias then average the sum Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM
formula to find 2 or more criterias then average the sum Excel 2010 formula rounds - arithmetic average calculation YooNaa Kim Excel 1 06-07-2011 08:50 PM
'AVERAGE' Formula nfphilpot Excel 3 11-24-2010 02:19 PM
Find duplicates formula hannu Excel 2 10-26-2010 02:48 AM
Needs help to find excel formula- Please aamer_1983 Excel 2 07-13-2009 01:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 AM.


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