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?

countif
 

Try this:

D1 = 2pm

=COUNTIF(A1:A3,C1&D1)

I don't know where you have 2pa entered but the formula would follow the
same syntax:

E1 = 2pa

=COUNTIF(A1:A3,C1&E1)

--
Biff
Microsoft Excel MVP


"old coach" wrote in message
...

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?




--
old coach