Sumif sum vlookup ?

[Azzheasman]

Heya,

I have a problem with a SUMIF, the bugger works on a different sheet but using the exact same formula on a simpler sheet and it seems not to do anything -_- .

I have a report that is auto run, the same data is in it but sometimes the number of names is different, the maximum number of names will be say 50 and the report depending who's in will show up to 50 names, because of this i can't do a standard =sum(sheet2!a2) as A2 on Sheet2 may not always be John Smith. So i created a sum if to say if anything in column A says John Smith (or in this case Sheet3!a1, which contains John Smiths name) but it wont return the data in the column next to his name.

Development Support Meeting Training Total

Huw Bennett

So what i need is find Huw's name on the Filtered sheet and then show the value in the development column next to it.

I know SUMIF is probably the wrong approach but it's worked before and now nothing lol

Any help would be greatly appreciated

Azz

[Glenn Kennedy]

The problem is not the SUMIF, but the data in CCVP raw. The times are stored as text. Amend your formula in tracker like this:
=IF('CCVP RAW'!W11="","",'CCVP RAW'!W11+0) to turn it back to a number and format the cells as [h]:mm:ss

[Glenn Kennedy]

Sorry, I meant "filtered" - not "tracker"....

[Azzheasman]

Awesome! thank you so much lol been tearing my hair out over this one !

Thanks again !

[Glenn Kennedy]

You're welcome and thanks for the Reputation.