of course, should have thought of that myself. Wood for the trees syndrome.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mhz" wrote in message
...

I Found a slight workaround for the Formula I presented wanting to use
the LEFT Function...

=SUM(COUNTIF(INDIRECT("DAY"&ROW(INDIRECT("1:31"))& "!G6:G35"),"GI*"))

Simply Counting Anything within the G6:G35 Range that Begins With "GI"
This Works for me just as well as using the LEFT Function...:)

Thanks for the assistance on this topic..;)


--
Mhz
------------------------------------------------------------------------
Mhz's Profile:
http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=565502