Originally Posted by
s-vadik
Of course!
In the file you have provided the range of criteria for room is set. They are
1010
2020
2130
But also we need a room with noname - "". If we expand the range to one more empty cell, it doesn't work - so you add this part to the final formula
'+($C$2:$C$10="")' to count stock in room "" as well.
It works, but if the situation changes and we no longer need the room "", I can not just change values in CRITERIA range, I must change the final formula to exclude this part.
I want to make it more general - find a way to poot room "" together with all the other criterias in the CRITERIA range and make it work.
One way is to change "" to "-" in the data, but this table is formed by SAP each day, and I'm not sure it would be possible to do it automatically.
I tried to be clear)
Possibly you can use this formula...
Where any of the cells in H2:H5 could contain a blank for the Room #
This adds a virtual dash to all entries in C and H so that blanks will seem like dash (-) instead.
Bookmarks