In the attached document I get an Error 504 when I try to use DCOUNTA to pull data from the named array on sheet 2. I am not sure what I’m doing wrong.
DCOUNTA Error 504.ods (58.3 KB)
Just try to change “Signup Cost Cat” in cell M3 to “Signups” (like as this field named in MARKETING_PERF)
See here: The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1 (in your case it is range J3:M3 and $marketing_perf.A1:H1)
In MARKETING_PERF I also have a Signup Cost Cat in cell J1. This is the cell I’m trying to reference.
Will LO only understand them if I have all the headers in order? I only need to reference 4 of the 12 headers in MARKETING_PERF, but the headers I need are not in column order. On my sheet the headers I need are cells B1, C1, G1, and J1.
[Edit] - To rephrase my question. Do I need to set up so the table has all 12 headers and in the same exact order? Currently I have Campaign and Category switched on MARKETING_PERF vs the dashboard. Is that an issue?
But MARKETING_PERF contain columns A:H (not J)
No, it’s not a problem. Just correct the text and get 47 instead of Error 504. Go to the original array and recalculate the records that match the specified criteria. There are exactly 47 of them. Conclusion - you don’t need ALL fields for the function to work
1 Like
Thank you @JohnSUN ! My MARKETING_PERF array was not reflecting the data I needed. Wow I was up for hours trying to figure this out. Thanks again!