I have a table of data in Excel with each row possessing multiple columns. For the sake of simplicity, let’s call them A and B. I want to count the rows wherein which the sum of A and B is less than integer X. Normally, I would set up two rows for this criteria: the top would have the label for the column, and the bottom would have the criteria itself.
---- |A | ---- |<X| ----
That works just fine, but if I do something like this, the DCOUNT function just returns 0, which is an incorrect answer:
------- |A + B| ------- |<X | -------
Obviously there is something incorrect with the
A + B syntax, but I can’t figure it out. None of the examples for DCOUNT I have found demonstrate the use of functions in criteria. I also saw this, but it doesn’t seem to be entirely relevant.
I am also aware that it would be possible to make an additional column with the sum of A and B and use that for the criteria, but that seems unnecessarily redundant.
With data in columns A and B, put your criteria in, say, D1 and D2. D1 must contain a header that is not present in your headers, and D2 is your formula. D2 contains this formula:
DCOUNT() looks like this: