C
cpliu
This is for surveys comparing before and after.
For example, there are 2 columns below, 1st is before, 2nd is after
3,5
5,5
4,5
4,5
2,5
3,5
....
Is there a way I can calculate:
total number of difference beween 2 columns for increase of 1, 2, 3,
and 4 or decrease
total number of each type of increase: ie. total 5 to 5, 4 to 5, total
of 3 to 5, etc
I've explored COUNTIFbut how do you have condistions in the criteria
(column b - column a = 1) or mulitple conditions (column b - column a
= 1 and column a = 4)?
thanks for your help,
For example, there are 2 columns below, 1st is before, 2nd is after
3,5
5,5
4,5
4,5
2,5
3,5
....
Is there a way I can calculate:
total number of difference beween 2 columns for increase of 1, 2, 3,
and 4 or decrease
total number of each type of increase: ie. total 5 to 5, 4 to 5, total
of 3 to 5, etc
I've explored COUNTIFbut how do you have condistions in the criteria
(column b - column a = 1) or mulitple conditions (column b - column a
= 1 and column a = 4)?
thanks for your help,