IFCOUNT formula help

I need help... I'm using Excel 2007
I am making a Monday-Sunday employee schedule and I would like to am tring to add a Vacation Value. When I type "VAC" I have it add 8 hours to the total hours column With =IF(COUNTIF(B6,"*vac*"),8,0)

That works perfectly


What I'm tring to do is have a formula that will count the number of times I "VAC" in the row and multiply that by my true value of 8. Like if they take 2 "VAC" days it will add 16 to the total hours
but cant figure out how to write it...

The only thing I can do is add...

=IF(COUNTIF(B6,"*vac*"),8,0)+IF(COUNTIF(C6,"*vac*"),8,0)+IF(COUNTIF(D6,"*vac*"),8,0)+IF(COUNTIF(E6,"*vac*"),8,0)+IF(COUNTIF(F6,"*vac*"),8,0)+IF(COUNTIF(G6,"*vac*"),8,0)+IF(COUNTIF(H6,"*vac*"),8,0)

But there has to be a simple-shorter way right......Please help

Try it like this...

=COUNTIF(B6:H6,"*vac*")*8