Excel data functions

G

GoBobbyGo

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?
 
G

GoBobbyGo

Apologies. That's what I get for using a very old bookmark - I misremembered
that I could post questions for all MSOffice apps here. My question (and the
one I posted immediately after, also here) are both now on the appropriate
Excel page. Any I can remove this whole thread?

:

Sorry. This is a newsgroup dedicated to questions about Access, the
 
Top