reading values every 2 column
Hello all,
I’ve been through the formulas and functions directory to solve my problem but I couldn’t write the thing correctly using the references functions.
I have about 20 rooms (and more to come), and each room is provided with different water meters.
At the moment i read only one meter in each room. In the future i might have to read several in each room.
What I did is:
- each column is a room; name of the room in the head row
- Under the name of each room are 2 columns: 1 for the global meter of the room, one for the specific meter
- rows are months
What I wish to do is:
read the value of specific meter in each room and work it with price unit to fond out the cost in the Cost Table.
In my case it means:
-go and read the value in the Specific Meter column and insert it with computation in Cost Table.
-do it again in the next room (C+2 column) and put it in the C+1 Cost Table.
I tried to use the LOOKUP function, ADDRESS, IMPAIR, etc, but I couldn’t find my way to extract a value every 2 column from one table and insert it in every column in a new table.
If anyone is familiar with this, I’m all ears…
Thank you very much for taking time to read me.
Lionnel
PS: Since 1 room can contain several meters, and therefore columns, It might be smarter to set Rooms in rows and months in columns ...?
iMac, OS X El Capitan (10.11.3)