Since each now only represents half an hour, we'll change the counter from 1
to 0.5:
=SUMPRODUCT(0.5*ISTEXT(C6:W6))

Note that the previous formula was an array formula, while this one is not.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hoops" wrote:

I am trying to adjust a formula to include more cells...I don't understand
the formula that well. It's for a employee work schedule. I've changed it
to go from hourly to every half hour. If there is text within certain cells
then it should equal a half hour of work for that employee. The formula
right now based on hourly is: =SUM(IF(ISTEXT(C6:K7),1,0)) The schedule goes
from 7am to 3pm (example c5 is 7am, then d5 is 8am and so on until 3pm) I
want to change: c5 to 9am, d5 to 9:30, e5 to 10:00 and so on all the way to
7pm. If there is any text within c6 and w6 (which would be 7pm) then I want
the formula to give me total hours worked.