Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

=SUMIF([parket.xls]parket'!$B:$B;B4;[parket.xls]parket'!$D:$D) is not working for me

Posted by Brynjar Hallmannsson on May 15, 2001 1:27 AM

I have this workbook, (ParketPrices) where I use values from another workbook, (Parket). The problem is that there can be identical value´s in row B in (parket) I don´t want to use the sum of these values. I need to get the first occurance and use that one in the other workbook (ParketPrices).
Regards,

Check out our Excel Resources

Re: =SUMIF([parket.xls]parket'!$B:$B;B4;[parket.xls]parket'!$D:$D) is not working for me

Posted by Dave Hawley on May 15, 2001 1:51 AM

Hi Brynjar

Sounds like you need a Lookup formula, try VLOOKUP eg;
=VLOOKUP(B4,[parket.xls]parket'!$B:$D,3,FALSE)

..or have a look at INDEX and MATCH

Dave

OzGrid Business Applications

Re: =SUMIF([parket.xls]parket'!$B:$B;B4;[parket.xls]parket'!$D:$D) is not working for me

Posted by Brynjar Hallmannsson on May 15, 2001 3:37 AM

Thanks it´s working smoothly now =|;-)>--

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.