View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
n_sabra64 n_sabra64 is offline
external usenet poster
 
Posts: 1
Default Increasing number depending on input

Bear with me I am an Excel novice,

I am trying to figure out what formula I need to increase a number in a
certain cell, in response to an input from another cell.

Example:
In Cell C2, If B2 equals 1, I need the number in C2 to increase by 1
......but I also need the number in C2 not to change if another number is
entered.

Basically B2 will increase the numbers in other cells depending on what is
entered.


This is for a survey type form, and I need to track how many 1's, 2's, 3's,
etc. are entered.