transpose values based on mulitple criteria

		Microsoft Office Forums > Microsoft Excel > Excel
transpose values based on mulitple criteria

FAQ

Thread Tools

Display Modes

12-06-2013, 02:00 AM

Pecoflyer

Windows 7 64bit transpose values based on mulitple criteria

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

In C20 enter

Code:

=SUMPRODUCT(($A$5:$A$13=C$17)*($B$5:$B$13=C$18)*($C$5:$C$13=C$19)*INDEX($D$5:$F$13,,MATCH($A20,$D$4:$F$4,0)))

and pull down and across

Attached Files

Book3(1).xlsx (12.0 KB, 9 views)

__________________
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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MACRO - Insert row based on Form Field Criteria	Elan05	Word VBA	5	04-16-2013 06:39 AM
Transpose cells and skip?	ItsjustB	Excel	1	01-09-2013 08:53 AM
Conditionally Email People Based on Values in Fields	dawsonh2002	Mail Merge	2	12-12-2012 12:11 PM
change values based on cell	ubns	Excel	1	05-21-2012 06:28 PM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 AM.