B
BJ&theBear
I am currently working on a spreadsheet where I need to solve two
problems both of which I think can be done with Sumproduct but
unfortunately I am having difficulty getting my head round it.
I basically want to add up the corresponding entries which satisfy two
conditions and then three conditions
The worksheet called "chargeablehours" has multiple columns but the
four important ones are:-
Column A - Project ID
Column D - CLSStage
Column H = Date
Column I - Hoursworked
In an seperate worksheet "Menu" (within the same workbook) I want to
be able to do two seperate calculations using the information input
into
A1 - input Project ID
B1 - input CLSstage
C1 - input startdate
D1 - input enddate
The first formula needs to extract all entries where the ProjectID and
CLSstage are equal to A1 and B1 and sum the hoursworked in Column I
The second formula needs to extract exactly the same information (sum
hoursworked) but where the dates in column H are between the input
startdate and enddate.
I hope this makes sense
Any help would be most appreciated
BJthebear
problems both of which I think can be done with Sumproduct but
unfortunately I am having difficulty getting my head round it.
I basically want to add up the corresponding entries which satisfy two
conditions and then three conditions
The worksheet called "chargeablehours" has multiple columns but the
four important ones are:-
Column A - Project ID
Column D - CLSStage
Column H = Date
Column I - Hoursworked
In an seperate worksheet "Menu" (within the same workbook) I want to
be able to do two seperate calculations using the information input
into
A1 - input Project ID
B1 - input CLSstage
C1 - input startdate
D1 - input enddate
The first formula needs to extract all entries where the ProjectID and
CLSstage are equal to A1 and B1 and sum the hoursworked in Column I
The second formula needs to extract exactly the same information (sum
hoursworked) but where the dates in column H are between the input
startdate and enddate.
I hope this makes sense
Any help would be most appreciated
BJthebear