You can use other formulas to get the same result as most of the D functions

I know I can use vlookup in some situations and sumif in others, but neither
of them allows me to refer to a column header by name. I guess I could get
around it with named ranges and the indirect() function I just learned about,
but that's pretty cumbersome too. VLOOKUP doesn't seem to work if the
information I need is to the left of the identifier column.

Or did you mean other formulas? If so, which?

I assume the D functions are there because Lotus had them
Yes, I need to convert a whole bunch of spreadsheets from 1-2-3 to Excel

"Peo Sjoblom" wrote:

You can use other formulas to get the same result as most of the D
functions, I assume the D functions are there because Lotus had them

--

Regards,

Peo Sjoblom

"GoBobbyGo" wrote in message
...
Why do DGET, DSUM, etc require a range as the criteria, and one that must
be
at least 2 cells high, at that.

I've got a whole chart of things that need to call on these functions and
the one-row-mapping-into-two thing is NOT helpful.

Yes, yes, I get it, I can stick side-by-side columns off to the side
somewhere and get around it, but it's unbelievably cumbersome.

Why can't I, instead of having to use a range as criteria, just specify it
right in the function?