Re: SumProduct Function

cuz this function does NOT take whole columns.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Mike H." <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:489ADE1A-05BF-432C-B24C-99A91BB843A4@xxxxxxxxxxxxxxxx
I just figured out why sometimes a sumproduct function would work and
sometimes why it would return #NUM instead. If one of the elements is stated
like this: ($A:$A = "XYZ) it will fail, whereas ($A1:$A65537="ABC") then it
works. Anyone know why? And is there an easier way to state an entire
column in a formula in a cell?

.

Relevant Pages

  • Re: Countif - Array Question
    ... Don Guillett ... Microsoft MVP Excel ... "Mike" wrote in message ... I tried using a COUNTIF array function like this: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: formula to do a count for info in another column
    ... Don Guillett ... Microsoft MVP Excel ... "mike" wrote in message ... If column A row 1 has the text "IT-MDU" how can I in column B write a ...
    (microsoft.public.excel.misc)
  • Re: Formula Error
    ... "Don Guillett" wrote: ... Microsoft MVP Excel ... "Mike H" wrote: ... Cell AC17 = 2 ...
    (microsoft.public.excel.programming)
  • Re: Formula or value
    ... Don Guillett ... Microsoft MVP Excel ... "Mike D." ... have been typed in and some have a VLOOKUP formula that generates the value. ...
    (microsoft.public.excel.misc)
  • Re: hidden worksheet
    ... Microsoft MVP Excel ... "Don Guillett" wrote: ... > For Each anySheet In Worksheets ... > into hidden state and run the MakeJustHiddenVeryHidden macro. ...
    (microsoft.public.excel.misc)