Forum Discussion
Structured References Issue
I'm having an issue with my structured reference formula. It is part of a workbook for my job. And on one worksheet, I have a table. As folks check in, I have a timestamp put on it. in a column, outside of the table, I have a formula that extracts the hour. Then in another worksheet, I need it to break down the check ins, based upon who they are on a lot of criteria and that hour. So it looks at one column in the table, and one column out of the table. It does and a SUM and a COUNTIF. All the while, I'm trying to work in a structured reference. I've been trying to achieve this for three days now and all I get is #VALUE!. or everyday, when I re-enter information, it's as if the formulas are reset. I work a high security job, so I would like to try and resolve this without uploading my workbook. If I can't, then I will have to just figure it out on my own. I can't upload my workbook for security reasons. I hope this can be understood.
8 Replies
It's not necessary to upload your working workbook. You may spend 10-15 minutes and generate simple sample workbook which illustrates an issue. Without it it's hard to say something concrete.
SergeiBaklan Hopefully this will work. The form I'm having an issue with is the Lodging List. It feeds from the Rooming List tab.
Thank you. An error is since in formula
=SUM(COUNTIFS('Rooming List'!H2:H252,"<=14",RoomingList[BRANCH],{"DAR/APP","DAR/ENL","DAV/APP","DAV/ENL"}))ranges 'Rooming List'!H2:H252 and RoomingList[BRANCH] are of different size. Formula requires the same size of the ranges. You may modify it as
=SUM(COUNTIFS($H$2:INDEX(H:H,ROWS(RoomingList)+1),"<=14",RoomingList[BRANCH],{"DAG/APP","DAG/ENL"}))(see in cell B24), when it works. At least in this part.
