Forum Discussion
Structured References Issue
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.
- SergeiBaklanJul 22, 2020Diamond Contributor
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.
- FrameofLightDesignerJul 22, 2020Copper Contributor
SergeiBaklan That worked beautifully! I can't thank you enough! I've been trying to fix that for 5 days now! You're amazing!
- FrameofLightDesignerJul 22, 2020Copper Contributor
SergeiBaklan I spoke to quickly. It's not working in every cell. It worked in B24 and E24, but not C24 and J24, so far. What could be the cause?