#1
|
|||
|
|||
Formula to depend on multiple cell-values
Hey guys.
Another problem I can't solve, but I guess it's kinda simple. Been trying with vLookup but doesn't get it to work I want cell H10 to check what value cell B10 has (there are 6 different ones cuz it's a dropdownlist). And also check what value cell D10 got. And from that, evaluate the value to be shown in cell H10. The data it will check for is on Sheet3 "DATA". For example. If B10 = Tidningar & D10 = 370L. H10 should show the result of DATA!D17 - "81". ref. (B10 = Tidningar 'Check Sheet3 -> A16' => then check D10 = 370L 'Check Sheet3 -> B17 => H10 = 81) If they collumns or so are missplaced, feel free to put them in the right order The DATA sheet3, has all the rawdata for my formulas. Why I want it to depend on B10 is beacuse it's not yet complete and the other ones got different prices. Is it possible to do this? |
#2
|
|||
|
|||
Quote:
Code:
=SUMPRODUCT((Data!$A$16:$A$37=Kalkyl!$B10)*(Data!$B$16:$B$37=Kalkyl!$D10)*(Data!$D$16:$D$37)) |
#3
|
|||
|
|||
Quote:
Didn't know I could use that one. ++++++! |
#4
|
|||
|
|||
If you're interested in a reference...
Here's at least one... http://www.xldynamic.com/source/xld.SUMPRODUCT.html |
#5
|
|||
|
|||
Quote:
|
|
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 |