hi, I am trying to modify the formula below to use the LEFT function.. any help Appreciated..

=SUM(COUNTIF(INDIRECT("DAY"&ROW(INDIRECT("1:31"))&"!H6:H35"),"=W"))

I tried this below, but I get a reference error:

=SUM(COUNTIF(INDIRECT("DAY"&ROW(INDIRECT("1:31"))&"!(LEFT(H6:H35,1"),"=W"))

Thanks In Advance..