rajkumar
03-04-2009, 01:54 AM
Hi Experts,
I have an excel report to calculate productivity of engineers.
There is a pivot table (summary call per CE) which has multiple page fields.
When i choose Month as Jan i could see the number of call done by each engineer. Similarly i am able to choose each month and check out calls.
Now what i need is how to use sum if formula with range offset.
here when we choose Jan month there will be 6 columns in the pivot. but when feb is chosen then we have only 5 columns (ie: install column will be absent since there is no new machine installed that month)
I used vlookup to get values from the pivot but i will get only the first match of vlookup not the sum of every match.
I have attached a sample workbook herewith.
Kindly help
Raj :help
I have an excel report to calculate productivity of engineers.
There is a pivot table (summary call per CE) which has multiple page fields.
When i choose Month as Jan i could see the number of call done by each engineer. Similarly i am able to choose each month and check out calls.
Now what i need is how to use sum if formula with range offset.
here when we choose Jan month there will be 6 columns in the pivot. but when feb is chosen then we have only 5 columns (ie: install column will be absent since there is no new machine installed that month)
I used vlookup to get values from the pivot but i will get only the first match of vlookup not the sum of every match.
I have attached a sample workbook herewith.
Kindly help
Raj :help