Hello, I've searched everywhere with no avail to my problem. Perhaps someone here who is more knowledgeable can help me with
I have a worksheet where I am trying to total how many employees kids will be attending an event, and
it must be based on a few criterias.
The column I am having problems with must have this result:
Only include child in Total column if a "1" is entered in the attending field and if child is between ages 3 and
12. Children 2 and under are free to attend so they are totaled in a seperate column.
My worksheet looks a little
something like this:
1_|_Child 1_|__Date of Birth_|_Age as of Dec. 1_| __Attending_|_Total Kids__|
2_|__ Joe__|____2/01/08___|_______3________|_____0 _____|____1______|
There are columns like this for up to five
I was able to calculate ages using a COUNTIF function, but failed to implement the attending
This is what I would have entered in the Total Kids column for this example (just to check age):
My actual formula is much larger however, since there are fields for 5 children. It looks like this:
This results in a child being added to the total column, even though he is not marked as attending yet. Is there any way that
i can correct this to ONLY count a child in the total column if it meets the conditions of older than 2, younger than 13, and
marked as attending? (all in one function?)
I am using excel 2003, and this needs to be calculated without
implementing another table (such as required in a DSUM, pivot table, or things of the like). If I shouldn't be using COUNTIF,
please direct me otherwise.
Sorry for the long post, or if I posted in the wrong section. Any help is greatly