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
|