Try this:
=SUMPRODUCT((A2:A100="P")*(B2:B100="cps"))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"ferde" wrote in message
...
I'm not sure which function I need to add text "p" and "cps" when this
data is in different columns. The total in this ex: would be p+cps = 2.
Any help would be greatly appreciated. I'm new at this.
shift class
p cps
p x
p x
p x
p cps
total p+cps = 2
|