Formula to depend on multiple cell-values

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Formula to depend on multiple cell-values

05-20-2017, 10:20 AM

NoSparks

Windows 7 64bit Formula to depend on multiple cell-values

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Quote:

Been trying with vLookup but doesn't get it to work

Have you tried completing column "A" of that table portion of the Data sheet and using a SumProduct formula ?

Code:

=SUMPRODUCT((Data!$A$16:$A$37=Kalkyl!$B10)*(Data!$B$16:$B$37=Kalkyl!$D10)*(Data!$D$16:$D$37))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and replace multiple values, according to table value - excel formula	EtanM	Excel Programming	3	04-11-2016 01:43 AM
IF Formula - multiple values	Jac_Fcb	Excel	1	03-17-2015 12:41 AM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:02 PM.