Category counting

  • Thread starter Thread starter Nornny
  • Start date Start date
N

Nornny

Hi again, sorry for all my newbie challenged-ness. You guys have been
great help so far, I feel bad for constantly asking. I'm still in th
stages of brainstorming, but I have three sheets:

Sheet 1 has essentially two things: A column of text called "Codes" an
many columns of categories. Essentially, the worksheet puts an "x" nex
to the "category" that a "Code" is associated with. Each code i
associated with only 1 category. Ex.


Code
-------------------

Code-------Mammal----------Fish----------Reptile
Snake x
Dog x
Cat x

etc...

-------------------


In another sheet, I have a list of data for a month, with one of th
columns being "Codes". Ex:


Code
-------------------


Date--------------Animal---------------Code
3/4/04 yes Dog
3/5/06 yes Goldfish

etc...


-------------------



On my final worksheet, I have a list of categories, and I want to coun
the number of each type I had from the second sheet (Monthly dat
sheet). So ex:


Code
-------------------


# of Mammals 1
# of Fish 1
# of Reptiles 0


-------------------



Can this be done? I'm still brainstorming, haven't done much with it
but could use some creative thoughts to guide me along the way. Sound
like it's possible. Thanks in advance
 
Where is the number of the codes on the second, monthly sheet?
Your example only shows "Yes".
Does "Yes" mean one (1) code?
If you have 2 codes in one day, how is that depicted?
"yes - yes".

What are you using to total the codes from the first sheet, that transfers
the data to the second sheet?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi again, sorry for all my newbie challenged-ness. You guys have been a
great help so far, I feel bad for constantly asking. I'm still in the
stages of brainstorming, but I have three sheets:

Sheet 1 has essentially two things: A column of text called "Codes" and
many columns of categories. Essentially, the worksheet puts an "x" next
to the "category" that a "Code" is associated with. Each code is
associated with only 1 category. Ex.


Code:
--------------------

Code-------Mammal----------Fish----------Reptile
Snake x
Dog x
Cat x

etc...

--------------------


In another sheet, I have a list of data for a month, with one of the
columns being "Codes". Ex:


Code:
--------------------


Date--------------Animal---------------Code
3/4/04 yes Dog
3/5/06 yes Goldfish

etc...


--------------------



On my final worksheet, I have a list of categories, and I want to count
the number of each type I had from the second sheet (Monthly data
sheet). So ex:


Code:
--------------------


# of Mammals 1
# of Fish 1
# of Reptiles 0


--------------------



Can this be done? I'm still brainstorming, haven't done much with it,
but could use some creative thoughts to guide me along the way. Sounds
like it's possible. Thanks in advance!
 
Sorry the tables got kinda messed up. It's a bad habit of mine to never
preview a post. lol.

Date--------------Animal---------------Code
3/4/04----------- yes -------------------Dog
3/5/06 -----------yes---------------- Goldfish

Don't mind the Animal column or the date column, they are just examples
of the data properties. I'm looking solely at the code. There is no
counting on the second sheet, just the instances. I want to count the
instances of "Mammal" for example from this sheet in my third sheet
using the codes that ARE mammals in the first sheet. So my first sheet
is like the reference guide. If the second sheet has dog, cat, monkey,
etc..., I want it to be a count towards the mammal category. :) Hope
this helps.
 
Back
Top