countif?

[jswaim]

Okay, I think I am starting to get somewhere by using the countif. Well, part of the way there. I am using countif(a1:b2"cc15506") to count the model numbers. I still need to count multiple items. Such as: ($ represents separate columns)

Model $ Options $
cc15506 $ ae7 $ np5 $ 1sj $
cc15506 $ ae7 $ ne3 $ 1sj $
cc15506 $ b3r $ np5 $ 1sm $
Anyone have any suggestions on how I can count the number of models with the ae7 and 1sj options? Thank you.
This message was edited by jswaim on 2002-09-28 17:11

 

[Yogi Anand]

On 2002-09-29 10:24, jswaim wrote:
Thanks again, Yogi.
This way is even better because the data is actually lumped together. The previous ways I was having to convert text to columns. So you have helped me out even more. Thanks
Jason

Hi Jason:

Communication is the key -- right Jason!

The better we can communicate the situation to each other, the better we can make things all around.

Regards!

Yogi