functions within sumproduct or vlookup

  • Thread starter Thread starter eggman
  • Start date Start date
E

eggman

are you able to use functions like value() and indirect() inside o
sumproduct() and vlookup()? is there a good reference online for wha
can and cannot be included
 
your first point of reference is: excel help..

look at the TYPE of the argument you want to 'manipulate'

for instance COUNTIF must have a range in it's first argument..


EXCEL HELP on VALUE(text)
Text is the text enclosed in quotation marks or a reference to a cell
containing the text you want to convert.

NOTE: they use CELL.. which means.. not a RANGE of cells :)


your second point of reference is: experiment..
(select part of the formula on the formula bar and press f9 to have it
evaluate ... then see if formula produces an array of a single value)

in newer version you could use Evaluate Formula wizard..
(on formula auditingg toolbar)


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Back
Top