Adding and subtracting values

[JD83]

I have two columns E3:E63 with dropdowns that I need calculated as a value of 1 when a dropdown selection is chosen. I need to cross reference with column F3:F63 and if it contains certain words I need that value to decrease by 0.5. I can get the countif formula to work by using =Countif(E3:E63, "new") but I don't know what to add on to the formula to subtract .5 from it if one of the names from F3:F63 are selected (chanin, mark, chris, tim, isaac). Any help would be greatly appreciated!

 

[JD83]

I should also add I am using Google Sheets if that matters at all. Here is a sample of the sheet. I need it calculating the "new" section or "used" section as 1 and to subtract .5 if it's a split in Column F where "Chanin" is selected from the dropdown. If it says "no" split, then it can be the value of 1, but not in addition to.

 

[Joe4]

Welcome to the Board!

I should also add I am using Google Sheets if that matters at all.

Yes, it does matter. While there are many similarities, they are NOT the same programs -- there are many differences too!
As such, you should not post Google Sheets questions in the "Excel Questions" forum -- you should post them to the "General Discussion & Other Applications" forum, as per the description:

And then be sure to mention somewhere in your thread title or original post that this is a "Google Sheets" question.
I have moved this thread to that forum for you, so you should be all set now.