Formula to depend on multiple cell-values

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

05-20-2017, 11:19 AM

Challebjoern Challebjoern is offline

Windows 10 Formula to depend on multiple cell-values

Office 2007

Novice

Join Date: May 2017

Posts: 6

Quote:

Originally Posted by NoSparks

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))

Wow, just completed it and it worked like a charm with "Sumproduct". Thanks alot man!
Didn't know I could use that one. ++++++!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 08:08 PM.