Sum Multiple Criteria

[Chanley24]

Hi

I have extracted some wages data from our software at work with the intention of calculating out how many overtime hours our staff work in each pay week.

The extracted data contains 3 columns being pay date, transaction code and hours.

Overtime is represented as HALFA in the TRAN_CODE column and the overtime hours worked is represented by the number in corresponding cell under the HRS_AMOUNT column.

I have so far managed to use a =SUMIF(D2:D3537,"HALFA",E2:E3537) which sums ALL the HALFA hours for the whole selected array however i need to limit the sum to only summing the HALFA hours for a specified date.

I hope all that makes sense. I have attached the spreadsheet which i have included further explanations.

Any assistance would be greatly appreciated.

[:) Sixthsense :)]

In H12 cell

Please Login or Register  to view this content.

Drag it to right

[Pepe Le Mokko]

In H12 cell

Please Login or Register  to view this content.

Drag it to right

I would advise against using entire columns

[:) Sixthsense :)]

I would advise against using entire columns

No worries.. In General the Iteration will go upto the last used cell instead of whole column. Even myself not interested in referencing to whole column but some times I used to refer it based on the OP's comfort zone in case of any addition in data.

[Chanley24]

Hi Guys

Every week this data will be refreshed and every week there will be additional data due to our weekly pay run so i think referencing the whole column will work fine in this case.

Thank you both for your input and helping me out with this. it has been greatly appreciated.