countif from specific range
Try
=SUM(COUNTIF(A1:A100,{11;12;13;15;18;56;89;88;69}) )
--
Regards,
Peo Sjoblom
"shakey1181" wrote in message
...
I am trying to count data which falls within a specific non-sequential
range.
So i basically only want to count if the a1:a100 is equal to:
11,12,13,15,18,89,88,69,56, but i can't seem to find a way around it that
doesn't error
Would it help if i used a named range?
Thanks in advance.
|