Firstly thanks to all who replied, but I have an additional problem.
Column A has the data that I am searching for, and the SUMIF would work
ideally if all the corresponding values in column be were of the same format,
however column B will contain either 1, A, D or blank and I need also to add
1 to the total for every occurence of value A.
eg
Column A Column B
Mech Shift 1 1
Inst Shift 1 1
Elec Shift 1 1
Mech Shift 2 A
Mech Shift 3 D
I need a formula that will serch for every occurence of Mech in column A and
count only the 1's and A's in column B, so in the above case the total should
be 2.
In case anyone is wondering, A and D stand for arrival and departure.