Rob Webster
New Member
Hi all.
I'm struggling with a particular formula. not sure if this is possible unless I use VBA.
I have a raw data sheet where construction activities are valued. the value is spread over columns and each column represents the date when the work will be done.
the raw data sheet can have columns that are daily, weekly or monthly. and each line of data represents a particular resource that will be used for carrying out the activity.
each resource has a code an that code is used by the summary to work out the total in a particular month. The summary is always monthly but the day summarised in the month is not always consistent. i.e its not always the last day of the month.
I've attached a spread sheet to show you in better detail. which has 2 mock pages representing what I need to do. I've colour coded the cells for ease of showing the expected result of the formula.
I've tried SumIf but doesn't seem to be able to sum up more than 1 column of figures and also sum(if( .... in an array, but all only add up one column of figures.
thanking any one in advance that can help.
I'm struggling with a particular formula. not sure if this is possible unless I use VBA.
I have a raw data sheet where construction activities are valued. the value is spread over columns and each column represents the date when the work will be done.
the raw data sheet can have columns that are daily, weekly or monthly. and each line of data represents a particular resource that will be used for carrying out the activity.
each resource has a code an that code is used by the summary to work out the total in a particular month. The summary is always monthly but the day summarised in the month is not always consistent. i.e its not always the last day of the month.
I've attached a spread sheet to show you in better detail. which has 2 mock pages representing what I need to do. I've colour coded the cells for ease of showing the expected result of the formula.
I've tried SumIf but doesn't seem to be able to sum up more than 1 column of figures and also sum(if( .... in an array, but all only add up one column of figures.
thanking any one in advance that can help.
Attachments
Last edited: