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. ++++++!