Hi All,
Still working on this damn resource spreadsheet!
Now I am trying to add a range of cells depending on certain criteria. Please refer to the attached screen shot.
What i would like is a formula which looks for all 'billable' criteria in a range, then looks for all 'company' criteria in a range and if they are both true, add up the value(s) of an adjoining column.
In the example attached, i would like the formula to look up the 'billability' column AND the 'csg' column and if the cell in the billability column = 'billable' AND if the cell in the csg column = 'power' add up the corresponding values in W/E 19/02/2010. In this case the answer would be 4.
An additional variation to the formula would be to check for a combined 'non-billable' AND 'overhead' in the billability column AND if the cell in the csg column = 'power' add up the corresponding values in W/E 19/02/2010.
Again any assistance would be greatly appreciated. In this instance i am not looking for a response involving a pivot table.
Cheers.
Bookmarks