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
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