Which function to use......and how?

[Kurch]

My Excel column B has values like this: "4-1", "4-2", "4-3". These
values represent family types.

On the same row in column C there are the number of family members in
each family group is listed. For example, "3", " 5", "7".

At the bottom of the sheet I want to count the number of family
numbers in each family type. In other words, what is the total numbers
of family members in "4-1", "4-2", "4-3"?

What function do I use to sum the total numbers of family members in
each group?

Thank you

 

[GS]

Kurch wrote :

My Excel column B has values like this: "4-1", "4-2", "4-3". These
values represent family types.

On the same row in column C there are the number of family members in
each family group is listed. For example, "3", " 5", "7".

At the bottom of the sheet I want to count the number of family
numbers in each family type. In other words, what is the total numbers
of family members in "4-1", "4-2", "4-3"?

What function do I use to sum the total numbers of family members in
each group?

Thank you

Look at the SUMIF() function in the user guide. (F1)

 

[joeu2004]

My Excel column B has values like this: "4-1", "4-2", "4-3".
These values represent family types.

First, be careful: 4-1, 4-2 etc might be interpreted as dates. Enter them
either as ="4-1" or as '4-1 (apostrophe before 4-1).

On the same row in column C there are the number of family
members in each family group is listed. For example, "3",
" 5", "7".

At the bottom of the sheet I want to count the number of family
numbers in each family type. In other words, what is the total
numbers of family members in "4-1", "4-2", "4-3"?

What function do I use to sum the total numbers of family members
in each group?

=SUMIF(B:B,"4-1",C:C)

 

[Don Guillett]

My Excel column B has values like this: "4-1", "4-2", "4-3". These
values represent family types.

On the same row in column C there are the number of family members in
each family group is listed. For example, "3", " 5", "7".

At the bottom of the sheet I want to count the number of family
numbers in each family type. In other words, what is the total numbers
of family members in "4-1", "4-2", "4-3"?

What function do I use to sum the total numbers of family members in
each group?

Thank you

Send file to dguillett1 @gmail.com with explanation and before/after
example

 

[XLS S]

Hey,

Use counif function for count the value with condition
like..
=countif("range","4-1")