T
Fri May 09 12:22:24 CDT 2008
See this:
http://mcgimpsey.com/excel/formulae/doubleneg.html
--
Biff
Microsoft Excel MVP
"BrianL" <BrianL@discussions.microsoft.com> wrote in message
news:6958291A-FFFD-4EA1-A72B-D78FAF52840F@microsoft.com...
> Thanks, Biff. That worked great. Why do you need the double negative
> (--)
> at the beginning of the first array?
>
> "T. Valko" wrote:
>
>> >SUMPRODUCT doesn't apply here
>>
>> Sure it does. Try it. You might be surprised!
>>
>> The only difference is you can't use entire columns as range references
>> unless you're using Excel 2007 (but it looks like you are with a xlsx
>> file
>> type. However, I still wouldn't use entire columns as references *unless*
>> you're using *every* row)
>>
>> =SUMPRODUCT(--(your_path_$K1:K100=E3),your_path_$CL1:$CL100)
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "BrianL" <BrianL@discussions.microsoft.com> wrote in message
>> news:33324835-068D-4744-8D77-517204A1A75A@microsoft.com...
>> > SUMPRODUCT doesn't apply here; I just need to sum the entries in one
>> > column
>> > that meet my criteria:
>> >
>> > =SUMIF('Q:\Shared\blan\Revenue
>> > Estimates\[Revenue_Forecast_current.xlsx]Tail
>> > by Month'!$K:$K,E3,'Q:\Shared\blan\Revenue
>> > Estimates\[Revenue_Forecast_current.xlsx]Tail by Month'!$CL:$CL)
>> >
>> > "T. Valko" wrote:
>> >
>> >> Use SUMPRODUCT
>> >>
>> >> --
>> >> Biff
>> >> Microsoft Excel MVP
>> >>
>> >>
>> >> "BrianL" <BrianL@discussions.microsoft.com> wrote in message
>> >> news:92D4AD7A-6131-4D7F-8F74-3D0620F88C62@microsoft.com...
>> >> >I am using the sumif function to return values from a linked
>> >> >workbook.
>> >> >When
>> >> > the linked workbook is not open, however, the cells using this
>> >> > formula
>> >> > returns a #VALUE! error. Anyone have any suggestions to fix this?
>> >> >
>> >> > Thanks.
>> >>
>> >>
>> >>
>>
>>
>>