Formula to Determine How Many Times Someone Is Scheduled

=COUNTIF(B9:AA24,"NAME*")+COUNTIF(B30:AA30,"SM*")

When I try to split the formula above by columns I get an error and it no longer computes. What i need should look something like this:
=COUNTIF(c9:e24,"NAME*")+(F9:H24,"NAME*")+0.5+(I9:Z24,"NAME*")+(AA9:AC24,"NAME*")+0.5+COUNTIF(B30:AA30,"SM*")

Ideally the formula would count how many times a staff members name is typed in the worksheet and count it as 1 (which we interpret as 1 hour though I know that isn't the case) for the formulas with .5 behind it is because we need it to count that particular column as 1.5

Any help would be appreciated I've tried everything I can think of and can't get it to cooperate.

For starters you need a COUNTIF in front of the other pieces of your formula.
Hope that helps.

Did you try this :

Please Login or Register  to view this content.

Yes. I know. But NENE517 has written this formula above, where COUNTIF is missing in some places. So I wanted to know if I got his problem or not?

May be NENE517 is trying this:

Please Login or Register  to view this content.

But I am not sure about this from his description.

I hope the attachment shows, I'm new to this forum and not sure how it works. Thank you

Because COUNTIF: F9:H24 and AA9:AC24 need to count as 1.5 whereas the others should count for just 1.

I hope I'm explaining myself well

Originally Posted by sanram

may be nene517 is trying this:

Please Login or Register  to view this content.

but i am not sure about this from his description.

this worked!!! Thank you!!!

You are welcome.