countif
column a has:
102pm
102pa
102pm
column c has:
10
11
12
row d1.. has:
2pm
2pa
column c values will change weekly. i want a formula to work regardless of the value of column c.
the 1st 2 numbers are variables but the letters are constant.
i want to count the number of values that are the same and ener a total.
if c1+d1=a1 add it to the total count
in the example under 2pm the total would be 2
in the example under 2pa the total would be 1
how can i use the countif statement?
|