Formula to increment Cell numeric value using second cell contents in Excel 2016

[Sparky59]

I have three columns A B and C. Column A has member names column B has number of points accrued. I want to enter numeric data into column C and have it increment the total in Column B automatically.

Can anyone help with a formula to achieve this please?

Kind Regards
Sparky59

 

[Aladin Akyurek]

Care to post a small sample? No images please.

 

[AliGW]

Welcome to the forum!

I'm not quite sure what you mean. Do you want a formula in C that changes the value in column B (not possible without VBA), or do you want the result of the formula in C to show in C?

A visual of what you are anticipating would help.

 

[Sparky59]

How do I enclose a small sample spreadsheet page instead of an image?

 

[AliGW]

Grab yourself the ForumTools add-in (instructions in my signature line).

 

[Aladin Akyurek]

How do I enclose a small sample spreadsheet page instead of an image?

Select 5 rows from columns A:C, copy the selection, and paste it here. See: Attachments.

 

[Sparky59]

Hi AliGW, Not sure how to attach a Pic to show you...

 

[Sparky59]

Hi Aladin, please see below sample..

Name	Jan
John	0
Fred	0
George	0
Bert	0
I want to enter contributions from each member into column 'C' i.e.C2,C3,C4 etc
and have the contents added to B2, B3, B4 etc. and increment each time I add to the cell in Column 'C'

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Is 0 an amount or what?

In B2 enter:

=IF(A2="","",SUMIFS($C$2:C2,$A$2:A2,"?*"))

Is this what you are after?<strike></strike>

 

[Sparky59]

In the following example column B is the total amounts to be added. by inputting a numerical figure into the corresponding cell in column C I would like the cell in column B to increment each time by that amount in column C

A	B	C
Name	Jan
John	0
Fred	0
George	0
Bert	0
I want to enter contributions from each member
into column 'C' i.e.C2,C3,C4 etc
and have the contents added to B2, B3, B4 etc.
and increment each time I add to the cell in Column 'C'

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>