VLOOKUP to SUM all returned values

Hello.

This is hurting my head please help.

This formula works to return a value of a cell 10 columns to the right of a dropdown list value.

=VLOOKUP(A7,INDIRECT("'"&$H$5&"'!"&"$A:$J"),10,FALSE)

It only returns the value of the first instance of the dropdown list value in the range.

if I have two rows with the same value for "A7" in my range how can i return the SUM of them??


thank you

thanks but something didn't work.

See attached.
Other general comments welcome.

Many thanks

I beg your pardon. I should of explained more.

Going to create a new sheet per employee as per the template.
Users can select the project they work on from a dropdown list. then populate with the time they spend.

Then the master sheet will look to each users sheet and sum the total weekly hours spent for a specific project number.
Ive tried to make the formula rely on data from other cells so that it can be filled down and across or copied with no need to adjust the formula.

Cells in Row H of MASTER is where the most work is done.

it checks the value in A7 then searches a range of cells on the sheet called "value of H5"
It looks to the column 10 right of located instance - for the total.
I hope it can then return the SUM of all instances it finds the value of A7

essentially im looking for a better way to manage timesheets than the current manual way we do it.

Thanks

amazing thank you!!!

Originally Posted by Glenn Kennedy

OK. In C7, copy across and down

=IFERROR(SUMIF(INDIRECT("'"&C$5&"'!A:A"),$A7,INDIRECT("'"&C$5&"'!j:j")),"")

any way you could steer me in the right direction for my next task?

1) populating MASTER column A from all the other sheets column A's one per row, not duplicating and sorted into the same order as is the defined name list on the project number sheet?

offt that hurt even writing it down!