Hi
I have an Excel spreadsheet containing company inventories.
I have a sheet that has a list of all installed software. I have another sheet that calculates total installs (this has to be seperate for our auditing purposes).
The first sheet has the sofware titles at the top, e.g. Office (column A), Oracle (Column B), PSP8 (Column C), etc and so on... with row headings being each computer we have's ID. eg PC01
I transposed the column headings from the previous sheet into rows, so it now reads:
Row1: Oracle
Row2: Office
Row3: PSP8
etc, with the column headings on this sheet being "Licences held", "Installed", etc
In the 2nd sheet (where I calculate values), I have the following formula:
=(SUM('Main Inventory'!D$2
$63) + COUNTIF('Main Inventory'!D$2
$63,"Uninstal"))
This formula has to be copied downwards. The range from 2 to 63 has to stay the same (hence why I used partial absolute addressing). However, the column letter needs to change from D to E to F and so on as it is copied down. As it is, it doesn't do this. I somehow thought that having it as D$2
$63 would solve this problem
Help!
I have an Excel spreadsheet containing company inventories.
I have a sheet that has a list of all installed software. I have another sheet that calculates total installs (this has to be seperate for our auditing purposes).
The first sheet has the sofware titles at the top, e.g. Office (column A), Oracle (Column B), PSP8 (Column C), etc and so on... with row headings being each computer we have's ID. eg PC01
I transposed the column headings from the previous sheet into rows, so it now reads:
Row1: Oracle
Row2: Office
Row3: PSP8
etc, with the column headings on this sheet being "Licences held", "Installed", etc
In the 2nd sheet (where I calculate values), I have the following formula:
=(SUM('Main Inventory'!D$2
This formula has to be copied downwards. The range from 2 to 63 has to stay the same (hence why I used partial absolute addressing). However, the column letter needs to change from D to E to F and so on as it is copied down. As it is, it doesn't do this. I somehow thought that having it as D$2
Help!