John_Mc
07-06-2006, 08:10 PM
Hi All,
The end stages of creating some reports...be glad when it's over..but...
I am trying to sum values based upon two criteria.
I've attached an example with comments to make life easier.
I put raw data into the raw sheet (a data dowload of all the cost centres and accounts codes). I then run a macro to add up each instance of the account code for each cost centre. It pastes the data into the "Extracted" sheet.
From here I would like to be able to look up the end value. So on the "Sums" sheet, for cost centre 2001, I want to lookup up the values for all the agency staff employed. Agency staff account codes are 1180, 1181, 1182, 1183, 1184, 1184, 1395.
So add up all the values in these account codes (only for the relevant cost centre) and put it in one value on the sums tab.
Any ideas on if there is a specific function to do this (related to vlookup maybe?)
Cheers,
John Mc
The end stages of creating some reports...be glad when it's over..but...
I am trying to sum values based upon two criteria.
I've attached an example with comments to make life easier.
I put raw data into the raw sheet (a data dowload of all the cost centres and accounts codes). I then run a macro to add up each instance of the account code for each cost centre. It pastes the data into the "Extracted" sheet.
From here I would like to be able to look up the end value. So on the "Sums" sheet, for cost centre 2001, I want to lookup up the values for all the agency staff employed. Agency staff account codes are 1180, 1181, 1182, 1183, 1184, 1184, 1395.
So add up all the values in these account codes (only for the relevant cost centre) and put it in one value on the sums tab.
Any ideas on if there is a specific function to do this (related to vlookup maybe?)
Cheers,
John Mc