SUM IF Formuale
 

I am trying to develop a VBA project where information is entered on a
worksheet and when it is saved it is copied into another worksheet that
stores all the saved data. I am building a variety of reports that accesses
the main data worksheet.

I have a table where I would like to pull in information that requires me
looking up 2 variables e.g. I need to be abale to sum up all hours worked
where Column A = employee selected and Column B = a particular Contract Type.
I know the simplest way would be to add an additional column that would join
the results of the two columns but the number of transactions in this
workbook will change every week and the formulae would have to be copied down
repeatedly.

Is there any other way around this?

CiaraG

SUM IF Formuale
 

sumproduct will allow you to apply multiple conditions:
=sumproduct(--(a1:a10000="Employee A"),--(b1:b10000="Contract B"),c1:c10000)
will add up the values in c1:c10000 where A/B contain Employee A and
Contract B, respectively.

"CiaraG" wrote:

I am trying to develop a VBA project where information is entered on a
worksheet and when it is saved it is copied into another worksheet that
stores all the saved data. I am building a variety of reports that accesses
the main data worksheet.

I have a table where I would like to pull in information that requires me
looking up 2 variables e.g. I need to be abale to sum up all hours worked
where Column A = employee selected and Column B = a particular Contract Type.
I know the simplest way would be to add an additional column that would join
the results of the two columns but the number of transactions in this
workbook will change every week and the formulae would have to be copied down
repeatedly.

Is there any other way around this?

CiaraG