Average hours worked based on days worked during a pay cycle

I want to average the hours worked based on the number of days worked that week. In my example, the average reflects the 7 days of the week. I would like to create a formula that does not count those days the have 0.00 in the "hours worked" field. I am working with Excel 2007 and on the face it seems really simple but I am firmly in the land of "I can't see the damn trees cause this forest is in the way"

Please help!


Average hours.xlsx

try this...
=AVERAGEIF(E16:R16,"<>"&0)

let me know if that moved the forest for you?

Its moved the forest for me but could you explain what the & does I can figure everything else out

Thanks

Chris

sometimes =AVERAGEIF(E16:R16,"<>0") will give you an error, so by combining (concatenating) the "<>" with 0 gives you "<>"&0 - not equal to 0

in this case, you could also have used =AVERAGEIF(E16:R16,"<>0"), i just make it a habit to use the &

if that is a unique range (E33:R33) then you can just copy that formula down.

=AVERAGEIF(E33:R33,"<>0") you could also change the "<>0" to any other value you want

Originally Posted by FDibbins

sometimes =AVERAGEIF(E16:R16,"<>0") will give you an error, so by combining (concatenating) the "<>" with 0 gives you "<>"&0 - not equal to 0

in this case, you could also have used =AVERAGEIF(E16:R16,"<>0"), i just make it a habit to use the &

Many thanks, I think I will get into that habit as well.

Chris

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and thanks for the rep