help on formula for conditional addition

%3CLINGO-SUB%20id%3D%22lingo-sub-2218325%22%20slang%3D%22en-US%22%3Ehelp%20on%20formula%20for%20conditional%20addition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2218325%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20soft%20copy%20score%20pad%20for%20home%20use%20for%20the%20game%20Phase%2010.%20I%20want%20to%20add%20one%20more%20feature%20and%20I'm%20stuck%3A%3C%2FP%3E%3CP%3EExample%20-%20I%20need%20a%20formula%20where%20if%20a%20%22Y%22%20is%20entered%20on%20Cell%20C3%20then%20it%20will%20add%20a%20%2B1%20(looking%20at%20the%20number%20in%20Cell%20B3%20and%20putting%20a%20new%20total%20in%20B5).%20If%20an%20%22N%22%20is%20used%20for%20C3%20then%20the%20number%20does%20not%20increase%20and%20B5%20will%20be%20the%20same%20number%20as%20B3.%3CBR%20%2F%3EColumn%20A%20just%20show%20the%20%23%20of%20what%20round%20we%20are%20playing.%3CBR%20%2F%3EThe%20rows(see%20below)%20of%20the%20round%20played%20show%20the%20score%20and%20subtotal%20(%20I%20have%20used%20a%20basic%20formula%20to%20have%20a%20running%20total).%3CBR%20%2F%3EStarting%20with%20Column%20%22B%3A%20headings%20are%3A%20B3%3D%20PHASE%20%23%20%2F%20C3%3DMADE%20PHASE%3F%20%22Y%2FN%22%20D3%3DName%20-%20then%20repeats%20pattern%20to%20accommodate%20up%20to%206%20players%20using%20columns%20(A%20-%20S)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ERows%201%20%26amp%3B%202%20contain%20heading%20information%3CBR%20%2F%3ERow%203%20is%20where%20current%20phase%20%23%20is%20shown%20and%20the%20score%20for%20that%20round%3CBR%20%2F%3ERow%204%20show%20the%20subtotal%3CBR%20%2F%3EThis%20starts%20over%20on%20row%205%20(%20I%20have%20done%20enough%20rows%20for%2020%20rounds%20(Grand%20total%20is%20on%20row%2042)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2218325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am creating a soft copy score pad for home use for the game Phase 10. I want to add one more feature and I'm stuck:

Example - I need a formula where if a "Y" is entered on Cell C3 then it will add a +1 (looking at the number in Cell B3 and putting a new total in B5). If an "N" is used for C3 then the number does not increase and B5 will be the same number as B3.
Column A just show the # of what round we are playing.
The rows(see below) of the round played show the score and subtotal ( I have used a basic formula to have a running total).
Starting with Column "B: headings are: B3= PHASE # / C3=MADE PHASE? "Y/N" D3=Name - then repeats pattern to accommodate up to 6 players using columns (A - S)


Rows 1 & 2 contain heading information
Row 3 is where current phase # is shown and the score for that round
Row 4 show the subtotal
This starts over on row 5 ( I have done enough rows for 20 rounds (Grand total is on row 42)

1 Reply

@Honey_Tegler 

Same as Need help on formula - see my reply there.