Hi,
I'm trying to sum - well a SUMIF - of a column - if the criteria allows - but some cells in the column contain text, which I want to disregard. It's throwing errors as it's seeing the text and can't parse.
Screen Shot.pdf
What I want to do is count Column H - Number of Days Spent at Level - only if Column B - Level - contains 'Level 201'
So trying to sum the number of says spent at Level 201 for across all users.
I'm stuck between 2 formulas - that I need to somehow join together
=SUMIF(B8:B64,"Level 201",H8:H64)
=SUM(IF(ISNUMBER(VALUE(LEFT(H8:H64,2))),VALUE(LEFT(H8:H64,2)),VALUE(LEFT(H8:H64,1)))) - This is throwing the error as it gets stuck and doesn't recognise the letters Da - though it should be disregarding them?
Can anyone help?
Aisling
Bookmarks