Thread: countif
View Single Post
  #1   Report Post  
old coach old coach is offline
Junior Member
 
Posts: 14
Question 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?